Before You Begin
(1) The source CT-RDS MySQL database version is 8.0.
(2) The case-sensitive attribute is disabled for the source CT-RDS MySQL database.
(3) binlog is enabled for the source CT-RDS 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 only support full data migration, but not incremental data migration or auditing repair.
CT-RDS MySQL system databases such as MySQL cannot be migrated.
Table structure, full data, and incremental data of the source database can be migrated.
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 |
For the configuration on the source database, see Configure Migration Tasks with Self-built MySQL Database as Source.