Migrate the entire databases “clover” and “db01” and the k table under the test database.
block-allow-list:
bw-rule-1: # Name
do-dbs: ["clover","db01"]
do-tables: # Whitelist of upstream tables to be migrated.
- db-name: "test" # Name of the database containing the table to be migrated.
tbl-name: "k" # Name of the table to be migrated.
On the second day of trying, a colleague suggested using the web wizard. The configuration file generated by the web wizard is the same, but there are no errors, and the data is not migrated.
mysql-instances:
-
# Upstream instance or replication group ID.
source-id: "mysql-01"
# The name of the black and white list configuration item for the databases or tables to be migrated, used to reference the global black and white list configuration. The global configuration is seen below in the `block-allow-list` configuration.
block-allow-list: "bw-rule-1"
# Global black and white list configuration, referenced by each instance through the configuration item name.
block-allow-list:
bw-rule-1: # Name
do-dbs: ["db01","clover","test"]
do-tables: # Whitelist of upstream tables to be migrated.
- db-name: "test" # The name of the database containing the table to be migrated.
tbl-name: "k2" # The name of the table to be migrated.
- db-name: "db01"
tbl-name: "*"
- db-name: "clover"
tbl-name: "*"
|
username: Clover
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: