Azure Database for MySQL management stored procedures

APPLIES TO: Azure Database for MySQL - Single Server

Stored procedures are available on Azure Database for MySQL servers to help manage your MySQL server. This includes managing your server's connections, queries, and setting up Data-in Replication.

Data-in Replication stored procedures

Data-in Replication allows you to synchronize data from a MySQL server running on-premises, in virtual machines, or database services hosted by other cloud providers into the Azure Database for MySQL service.

The following stored procedures are used to set up or remove Data-in Replication between a source and replica.

Stored Procedure Name Input Parameters Output Parameters Usage Note
mysql.az_replication_change_master master_host
master_user
master_password
master_port
master_log_file
master_log_pos
master_ssl_ca
N/A To transfer data with SSL mode, pass in the CA certificate's context into the master_ssl_ca parameter.

To transfer data without SSL, pass in an empty string into the master_ssl_ca parameter.
mysql.az_replication _start N/A N/A Starts replication.
mysql.az_replication _stop N/A N/A Stops replication.
mysql.az_replication _remove_master N/A N/A Removes the replication relationship between the source and replica.
mysql.az_replication_skip_counter N/A N/A Skips one replication error.

To set up Data-in Replication between a source and a replica in Azure Database for MySQL, refer to how to configure Data-in Replication.

Other stored procedures

The following stored procedures are available in Azure Database for MySQL to manage your server.

Stored Procedure Name Input Parameters Output Parameters Usage Note
mysql.az_kill processlist_id N/A Equivalent to KILL CONNECTION command. Will terminate the connection associated with the provided processlist_id after terminating any statement the connection is executing.
mysql.az_kill_query processlist_id N/A Equivalent to KILL QUERY command. Will terminate the statement the connection is currently executing. Leaves the connection itself alive.
mysql.az_load_timezone N/A N/A Loads time zone tables to allow the time_zone parameter to be set to named values (ex. "US/Pacific").

Next steps