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

mysql.rds_stop_replication

Terminates replication from a MySQL DB instance.

Syntax

CALL mysql.rds_stop_replication;

Usage Notes

The master user must run the mysql.rds_stop_replication procedure.

If you are configuring replication to import data from an instance of MySQL running external to Amazon RDS, you call mysql.rds_stop_replication on the Read Replica to stop the replication process after the import has completed. 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 use mysql.rds_stop_replication to stop replication between two Amazon RDS DB instances. You typically stop replication to perform a long running operation on the Read Replica, such as creating a large index on the Read Replica. You can restart any replication process that you stopped by calling mysql.rds_start_replication on the Read Replica. For more information, see Working with Read Replicas of MariaDB, MySQL, and PostgreSQL DB Instances.

On this page: