We can use the replication Performance Schema tables to monitor to the connection status of all channels, or a subset of the existing channels.

To monitor the connection status of all channels, 

mysql> SELECT * FROM replication_connection_status\G;

 

 To monitor the connection status of a named channel, use a WHERE CHANNEL_NAME=channel clause: 

mysql> SELECT * FROM replication_connection_status WHERE CHANNEL_NAME='master1'\G;


  • No labels