vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/drs/umn/drs_11_0064.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

4.2 KiB
Raw Permalink Blame History

Checking Whether the binlog_row_image Value is FULL

MySQL

Table 1 Checking whether the binlog_row_image value is FULL

Check Item

Whether the binlog_row_image value is FULL

Description

If the binlog_row_image value of the source database is not FULL, the migration will fail.

Failure Cause and Handling Suggestion

Failure cause: The binlog_row_image value of the source database is not FULL.

Handling suggestion:

  • If the source database is an RDS DB instance on the cloud, change binlog_row_image to FULL on the RDS console, and then restart the source database.
  • If the source database is an on-premises database, perform the following steps:
    1. Log in to the server where the MySQL source database is located.
    2. Manually change the value of binlog_row_image in the my.cnf configuration file to FULL and save the file.
      binlog_row_image=full
    3. To ensure a successful task, restart the source database during off-peak hours.
Parent topic: Database Parameters