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

mysql.rds_stop_replication

Terminates replication from a MySQL DB instance.

Syntax

Copy
CALL mysql.rds_stop_replication;

Usage Notes

The mysql.rds_stop_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_stop_replication on the replica to stop the replication process after the import has completed. For more information, see Importing and Exporting Data From a 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 Using Replication to Export MySQL Data.

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 replica, such as creating a large index on the replica. You can restart any replication process that you stopped by calling mysql.rds_start_replication on the replica. For more information, see Working with PostgreSQL, MySQL, and MariaDB Read Replicas.

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

  • MySQL 5.5

  • MySQL 5.6

  • MySQL 5.7

Related Topics