TECHIES WORLD

For Techs.... Techniques.... Technologies....

AWSBashLinuxMysql

How to stop replication from external master in RDS MySQL

admin

RDS MySQL providing the option to configure replication from external master server.

To stop the replication from external master, the following queries need to be executed in RDS MySQL shell as admin user.

>CALL mysql.rds_stop_replication;

This will stop replicating data further from external master server. To remove the slave configuration completely, the following queries need to be executed in RDS MySQL shell as admin user.

>CALL mysql.rds_reset_external_master;

This will completely remove the slave configuration from RDS MySQL instance.

That's all…