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