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

CALL mysql.rds_reset_external_master;

Usage Notes

The master user must run the mysql.rds_reset_external_master procedure. This procedure 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. When you do so, we recommend that you use only this and other replication-related stored procedures. These practices enable more complex replication topologies between Amazon RDS DB instances. We offer these stored procedures primarily 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 Restoring a Backup into an Amazon RDS MySQL DB Instance.

On this page: