Saturday, November 20, 2021

RDS Mysql start and stop replica

 Mysql commands to stop and start the replica are different from the normal mysql replica command, 

To stop RDS Mysql replica use the below command:

CALL mysql.rds_stop_replication;



Start RDS Replication :


CALL mysql.rds_start_replication;


Kill Running Processes:


CALL mysql.rds_kill(processID);


Skip Replication Error :

CALL mysql.rds_skip_repl_error;


Check number of hours binary logs are retained


  CALL mysql.rds_show_configuration;



Set retention for binary logs:


CALL mysql.rds_set_configuration(name,value);







No comments:

Post a Comment