Jaa

Azure Database for MySQL management stored procedures

  • Artikkeli

APPLIES TO: Azure Database for MySQL - Single Server

Important

Azure Database for MySQL single server is on the retirement path. We strongly recommend that you upgrade to Azure Database for MySQL flexible server. For more information about migrating to Azure Database for MySQL flexible server, see What's happening 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