Add

Add data sources online without restarting the service

Field

Name : Unique name of data source, cannot be duplicate with other data source names, less than 30 numbers or letters

ConnectUri : mysql uri

BinlogFileName : Which site file to start parsing from. If it is empty, the latest MySQL site information will be automatically filled in when you click the check button

BinlogPosition : Which site file to start parsing from. If it is empty, the latest MySQL site information will be automatically filled in when you click the check button

ServerId : Can’t work with MySQL master database and other slave servers server_id is the same.If it is empty, a random number will be automatically generated when you click the check button

MaxBinlogFileName ,MaxBinlogPosition : When resolving to which point, close is dropped and no binlog analysis is performed.

GRANT

GRANT SELECT, SHOW DATABASES, SUPER, REPLICATION SLAVE, EVENT ON . TO ‘xxtest’@‘%’

If you are using AWS,Alicloud please do not select, please confirm whether you have sufficient permissions (do not check the “验证是否有足够权限”)

SQL that can be executed：

SELECT COLUMN_NAME,COLUMN_DEFAULT,IS_NULLABLE,COLUMN_TYPE,COLUMN_KEY,EXTRA,COLUMN_COMMENT,DATA_TYPE,NUMERIC_PRECISION,NUMERIC_SCALE FROM information_schema.columns WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?

SELECT COLUMN_NAME,COLUMN_KEY,COLUMN_TYPE,CHARACTER_SET_NAME,COLLATION_NAME,NUMERIC_SCALE,EXTRA,COLUMN_DEFAULT,DATA_TYPE,CHARACTER_OCTET_LENGTH FROM information_schema.columns WHERE table_schema= ? AND table_name= ? ORDER BY ORDINAL_POSITION ASC

SELECT SCHEMA_NAME FROM information_schema.SCHEMATA

SELECT TABLE_NAME,TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ?

SHOW GLOBAL VARIABLES LIKE ‘BINLOG_CHECKSUM’

SHOW MASTER STATUS

SHOW VARIABLES LIKE ‘server_id’

SHOW VARIABLES LIKE ‘binlog_format’

SELECT connection_id()

SELECT TIME,STATE FROM information_schema.PROCESSLIST WHERE ID = ?’

KILL connectiontId (Kill abnormal connection monitored by current account binlog)

Others

After adding a data source, the status is closed by default. After configuring the data table synchronization, click the start button to start