다음을 통해 공유

Azure Database for MariaDB management stored procedures

  • 아티클

Important

Azure Database for MariaDB is on the retirement path. We strongly recommend that you migrate to Azure Database for MySQL. For more information about migrating to Azure Database for MySQL, see What's happening to Azure Database for MariaDB?.

Stored procedures are available on Azure Database for MariaDB servers to help manage your MariaDB 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 MariaDB server running on-premises, in virtual machines, or database services hosted by other cloud providers into the Azure Database for MariaDB 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 MariaDB, refer to how to configure Data-in Replication.

Other stored procedures

The following stored procedures are available in Azure Database for MariaDB 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