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


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


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.


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 Read Replicas of MariaDB, MySQL, and PostgreSQL DB Instances.

For more information about using replication to import data from an instance of MySQL running external to Amazon RDS, see Importing Data into an Amazon RDS 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