Before You Begin
(1) The source self-built MySQL database version is 5.1, 5.5, 5.6, 5.7, or 8.0.
(2) The case-sensitive attribute is disabled for the source self-created MySQL database.
(3) binlog is enabled for the source self-built MySQL database and the format is row.
(4) The storage space of the target database must be greater than that used by the source database.
Limitations
Tables without primary keys support only stock data synchronization, not incremental synchronization.
MySQL system databases such as MySQL cannot be synchronized.
During migration, the table structure, full data, and incremental data on the source database can be synchronized.
Permission Requirements of Source Server
The permission query function must be designed into the two system tables, mysql.user and mysql.db. Therefore, users must be granted with the SELECT permission on the two tables.
Migration Mode | Required Permissions |
Full | SELECT, REFERENCES, INDEX, SHOW VIEW, TRIGGER Global level: PROCESS |
Incremental | SELECT. The binlog row mode is enabled. Global level: REPLICATION CLIENT, REPLICATION SLAVE |
Auditing Repair | SELECT |
Configuration on Source Server
Data source type: Set this parameter to MySQL. MySQL databases within the version range can be synchronized.
Server IP: Specifies the IP address of the source database to be synchronized.
Port number: Specifies the port of the source database to be synchronized.
User name: Specifies a user name used to connect to the source database to be synchronized.
Password: Specifies the password of the user used to connect to the source database to be synchronized.
Database: Specifies the name of the source database to be synchronized.