Stopping binary log replication for Aurora MySQL

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);

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.

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.

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