tencent cloud

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.