Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

mysql.rds_start_replication

Initiates replication from a MySQL DB instance.

Syntax

Copy
CALL mysql.rds_start_replication;

Usage Notes

The mysql.rds_start_replication procedure must be run by the master user.

If you are configuring replication to import data from an instance of MySQL running external to Amazon RDS, you call mysql.rds_start_replication on the replica to start the replication process after you have called mysql.rds_set_external_master to build the replication configuration. For more information, see Importing Data into an Amazon RDS MySQL DB Instance.

If you are configuring replication to export data to an instance of MySQL external to Amazon RDS, you call mysql.rds_start_replication and mysql.rds_stop_replication on the replica to control some replication actions, such as purging binary logs. For more information, see Exporting Data from a MySQL DB Instance by Using Replication.

You can also call mysql.rds_start_replication on the replica to restart any replication process that you previously stopped by calling mysql.rds_stop_replication. For more information, see Working with PostgreSQL, MySQL, and MariaDB Read Replicas.

The mysql.rds_start_replication procedure is available in these versions of Amazon RDS MySQL:

  • MySQL 5.5

  • MySQL 5.6

  • MySQL 5.7

Related Topics