To monitor the status of replication channels the following options exist:
Using the replication Performance Schema tables. The first column of these tables is
Channel_Name. This enables you to write complex queries based on
Channel_Nameas a key. See Performance Schema Replication Tables.
SHOW REPLICA | SLAVE STATUS FOR CHANNEL. By default, if the
FOR CHANNELclause is not used, this statement shows the replica status for all channels with one row per channel. The identifier
Channel_nameis added as a column in the result set. If a
FOR CHANNELclause is provided, the results show the status of only the named replication channel.
SHOW VARIABLES statement does
not work with multiple replication channels. The information
that was available through these variables has been migrated to
the replication performance tables. Using a
SHOW VARIABLES statement in a
topology with multiple channels shows the status of only the
The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error.