Amazon Relational Database Service
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

mysql.rds_start_replication

Initiates replication from a MySQL DB instance.

Note

You can use the mysql.rds_start_replication_until or mysql.rds_start_replication_until_gtid stored procedure to initiate replication from an Amazon RDS MySQL DB instance and stop replication at the specified binary log file location.

Syntax

CALL mysql.rds_start_replication;

Usage Notes

The master user must run the mysql.rds_start_replication procedure.

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 Read Replica to start the replication process after you have called mysql.rds_set_external_master to build the replication configuration. For more information, see Restoring a Backup 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 Read 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 Read Replica to restart any replication process that you previously stopped by calling mysql.rds_stop_replication. For more information, see Working with Read Replicas.

On this page: