Stopping binary log replication for Aurora MySQL (original) (raw)

1. Stop binary log replication on the replica target 2. Turn off binary logging on the replication source

To stop binary log replication with a MySQL DB instance, external MySQL database, or another Aurora DB cluster, follow these steps, discussed in detail following in this topic.

1. Stop binary log replication on the replica target

2. Turn off binary logging on the replication source

1. Stop binary log replication on the replica target

Use the following instructions to stop binary log replication for your database engine.

Database engine	Instructions
Aurora MySQL	To stop binary log replication on an Aurora MySQL DB cluster replica target Connect to the Aurora DB cluster that is the replica target, and call the mysql.rds_stop_replication procedure.
RDS for MySQL	To stop binary log replication on an Amazon RDS DB instance Connect to the RDS DB instance that is the replica target and call the mysql.rds_stop_replication procedure.
MySQL (external)	To stop binary log replication on an external MySQL database Connect to the MySQL database and run the STOP SLAVE (version 5.7) or STOP REPLICA (version 8.0) command.

2. Turn off binary logging on the replication source

Use the instructions in the following table to turn off binary logging on the replication source for your database engine.

Database engine	Instructions
Aurora MySQL	To turn off binary logging on an Amazon Aurora DB cluster Connect to the Aurora DB cluster that is the replication source. Use the mysql.rds_set_configuration procedure and specify the configuration parameter binlog retention hours, with the value NULL, as shown in the following example. CALL mysql.rds_set_configuration('binlog retention hours', NULL); NoteYou can't use the value 0 for binlog retention hours. Set the binlog_format parameter to OFF on the replication source. The binlog_format parameter is in the custom DB cluster parameter group associated with your DB cluster. After you've changed the binlog_format parameter value, reboot your DB cluster for the change to take effect. For more information, see Amazon Aurora DB cluster and DB instance parameters and Modifying parameters in a DB parameter group in Amazon Aurora.
RDS for MySQL	To turn off binary logging on an Amazon RDS DB instance You can't turn off binary logging directly for an Amazon RDS DB instance, but you can turn it off by doing the following: Turn off automated backups for the DB instance. You can turn off automated backups by modifying an existing DB instance and setting the Backup Retention Period to 0. For more information, see Modifying an Amazon RDS DB instance and Working with backups in the Amazon Relational Database Service User Guide. Delete all read replicas for the DB instance. For more information, see Working with read replicas of MariaDB, MySQL, and PostgreSQL DB instances in the Amazon Relational Database Service User Guide.
MySQL (external)	To turn off binary logging on an external MySQL database Connect to the MySQL database and call the STOP REPLICATION command. From a command shell, stop the mysqld service, sudo service mysqld stop Edit the my.cnf file (this file is usually under /etc). sudo vi /etc/my.cnf Delete the log_bin and server_id options from the[mysqld] section. For more information, see Setting the replication source configuration in the MySQL documentation. Start the mysql service. sudo service mysqld start

Setting up binlog replication

Scaling MySQL reads

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.