On this page

Show all

Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Binlog Retention Period Is Set on the Source Database

Checking Whether the Binlog Retention Period Is Set on the Source Database

Updated on 2022-09-21 GMT+08:00

MySQL Migration

Table 1 Checking whether the binlog retention period is set on the source database

Check Item

Whether the binlog retention period is set on the source database

Description

Checking whether the binlog retention period is set on the source database. You are advised to store the source database binlog for a longer time, if the storage space is sufficient.

Failure Cause and Handling Suggestion

Failure cause: The binlog retention period is not set on the source database.

Handling suggestion:

Log in to the source database and run the following SQL statement to set the retention period of binlog:

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

The value n indicates an integer from 1 to 168.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback