Compatibility with common data synchronization tools
Data synchronization tool | Compatible PolarDB-X instance version | Limits |
---|---|---|
MySQL Slave | >=5.4.11 | GTID-based replication is not supported. |
canal | >=5.4.11 | None |
DTS | >=5.4.11 | None |
debezium | >=5.4.12 | Snapshot is not supported. The snapshot.mode parameter must be set to never. |
maxwell | >=5.4.12 | None |
mysql-binlog-connector-java | >=5.4.11 | None |
Permissions required for an account to synchronize data
- By default, privileged accounts have full permissions.
- PolarDB-X 5.4.11 and later versions support binlogs that are fully compatible with MySQL. To
query and subscribe to the binlogs of an instance, you must use the
GRANT SELECT ON *.* TO 'user'@'host'
statement to grant your account permissions to perform the SELECT operation on the instance. This ensures data security. - PolarDB-X 5.4.12 and later versions support individual permissions to query and subscribe to
binlogs.
- You must have the
GRANT REPLICATION CLIENT ON *.* TO 'user'@'host'
REPLICATION CLIENT permission to run the following command to query binlogs:SHOW MASTER STATUS; SHOW BINARY LOGS;
- You must have the
GRANT REPLICATION SLAVE ON *.* TO 'user'@'host'
REPLICATION SLAVE permission to run the following command to query the details of binlog events and subscribe to binlogs.SHOW BINLOG EVENTS
- You must have the