mysql8插件_mysql8.0.23克隆插件的实践

# 在从库中执行操作

CHANGEREPLICATION SOURCE TOSOURCE_HOST='10.100.19.216',

SOURCE_USER='repluser',

SOURCE_PASSWORD='repluserpwd',

SOURCE_PORT=3306,

SOURCE_AUTO_POSITION=1;

start replica;

show replica status\G;

mysql>show replica status\G;*************************** 1. row ***************************Replica_IO_State: Waitingfor master tosend event

Source_Host:10.100.19.216Source_User: repluser

Source_Port:3306Connect_Retry:60Source_Log_File: mysql-binlog.000001Read_Source_Log_Pos:1401Relay_Log_File: relay-log.000002Relay_Log_Pos:1622Relay_Source_Log_File: mysql-binlog.000001Replica_IO_Running: Yes

Replica_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table: test.%La