MySQL: Enable Binary Logging

Self-Hosted Databases

To enable binary logging, configure the following parameters in MySQL’s my.ini (Windows) or my.cnf (UNIX) file:

• server_id - Set this parameter to a value of 1 or greater.
• log-bin - Set the path to the binary log file, such as log-bin=E:\MySql_Logs\BinLog. Don’t include the file extension.
• binlog_format - Set this parameter to ROW.
• expire_logs_days - Set this parameter to a value of 1 or greater. To prevent overuse of disk space, we recommend that you don’t use the default value of 0.
• binlog_checksum - Set this parameter to NONE.
• binlog_row_image - Set this parameter to FULL.
• log_slave_updates - Set this parameter to TRUE if you are using a read-replica as a source.

RDS Databases

To enable binary logging, follow these steps:

1. Enable automatic backups. For more information on setting up automatic backups, see Working with Automated Backups  in the Amazon RDS User Guide.
2. Ensure that the binary logs are available. Amazon-managed MySQL-compatible databases purge the binary logs as soon as possible so you should increase the length of time that the logs remain available. For example, to increase log retention to 24 hours, run the following:

command.call mysql.rds_set_configuration('binlog retention hours', 24);

3. Set the binlog_format parameter to ROW.
4. Set the binlog_checksum parameter to NONE.