vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/drs/umn/drs_11_0016.html
Wang , Deng Ke 5523220f09 DRS UMN 20221102 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-12-08 10:16:13 +00:00

3.1 KiB
Raw Permalink Blame History

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

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.
Parent topic: Database Parameters