reference-data-in-stored-procedures.md

title	description	services	author	ms.author	manager	editor	ms.service	ms.topic	ms.date
Azure Database for MySQL Data-in Replication Stored Procedures	This article introduces all stored procedures used for Data-in Replication.	mysql	ajlam	andrela	kfile	jasonwhowell	mysql	article	08/31/2018

Azure Database for MySQL 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 master 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 master and replica.
mysql.az_replication_skip_counter	N/A	N/A	Skips one replication error.

To set up data-in replication between a master and a replica in Azure Database for MySQL, refer to how to configure data-in replication.