Data synchronization tools for PolarDB-X - PolarDB - Alibaba Cloud Documentation Center

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	For more information, see Overview of data synchronization scenarios.
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

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
```