tencent cloud

Configuring Binlog in Self-Built MySQL
Download PDF
Last updated:2022-10-19 18:25:37
Configuring Binlog in Self-Built MySQL
Last updated: 2022-10-19 18:25:37
Download PDF

Overview

If the source database in a data migration, sync, or subscription task is a self-built MySQL, TDSQL for MySQL, or TDSQL-C for MySQL database, you need to set the binlog in the self-built database to meet the requirements for the source database during verification.

Operation impact

This operation requires database restart, which affects the business. We recommend you perform it during off-peak hours.

Directions

1. Log in to the source database.
2. Modify the my.cnf configuration file as follows:
Note:
The default path of the my.cnf configuration file is /etc/my.cnf, subject to the actual conditions.
We recommend you retain the binlog of the source database for at least three days; otherwise, the task cannot be resumed from the checkpoint and will fail.
Modifications in the my.cnf configuration file take effect permanently. If you want modifications to take effect only temporarily, run the set global expire_logs_days=3 command to make modifications.
You can also use binlog_expire_logs_seconds to modify the binlog retention period (in seconds) in MySQL 8.0 or later.
log_bin = MYSQL_BIN
binlog_format = ROW
server_id = 2 // We recommend you set it to an integer above 1. The value here is only an example
binlog_row_image = FULL
expire_logs_days=3  // Modify the binlog retention period (at least 3 days preferably).
3. Restart the MySQL process. 
[\\$Mysql_Dir]/bin/mysqladmin -u root -p shutdown
[\\$Mysql_Dir]/bin/safe_mysqld &
Note:
[\\$Mysql_Dir] is the installation path of the source database. Replace it with the actual path.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback