tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServicePreparationsConfiguring Binlog in Self-Built MySQL
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

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon