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 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 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