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

mysql.rds_reset_external_master

Reconfigures a MySQL DB instance to no longer be a Read Replica of an instance of MySQL running external to Amazon RDS.

Syntax

Copy
CALL mysql.rds_reset_external_master;

Usage Notes

The mysql.rds_reset_external_master procedure must be run by the master user. It must be run on the MySQL DB instance to be removed as a Read Replica of a MySQL instance running external to Amazon RDS.

Note

We recommend that you use Read Replicas to manage replication between two Amazon RDS DB instances when possible, and only use this and other replication-related stored procedures to enable more complex replication topologies between Amazon RDS DB instances. These stored procedures are primarily offered to enable replication with MySQL instances running external to Amazon RDS. For information about managing replication between Amazon RDS DB instances, see Working with PostgreSQL, MySQL, and MariaDB Read Replicas.

For more information about using replication to import data from an instance of MySQL running external to Amazon RDS, see Importing and Exporting Data From a MySQL DB Instance.

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

  • MySQL 5.5

  • MySQL 5.6

  • MySQL 5.7

Related Topics