content_image/668877.jpg
•Index on ( THREAD_ID ) 

The following table shows the correspondence between replication_connection_status  columns and SHOW REPLICA | SLAVE STATUS  columns. 

<img src='content_image/668877.jpg'>

## 27.12.11.3 The replication_asynchronous_connection_failover Table 

This table holds the replica’s source lists for each replication channel for the asynchronous connection failover mechanism. The asynchronous connection failover mechanism automatically establishes an asynchronous (source to replica) replication connection to a new source from the appropriate list after the existing connection from the replica to its source fails. You set and manage source lists using the asynchronous_connection_failover_add_source  and asynchronous_connection_failover_delete_source  functions to add and remove replication source servers from the source list for a replication channel. To add and remove managed groups of servers, use the asynchronous_connection_failover_add_managed  and asynchronous_connection_failover_delete_managed  functions instead. For more information, see Section 17.4.9, “Switching Sources with Asynchronous Connection Failover” . 

The replication_asynchronous_connection_failover  table has these columns: 

• CHANNEL_NAME 

The replication channel for which this replication source server is part of the source list. If this channel’s connection to its current source fails, this replication source server is one of its potential new sources. 

• HOST 

The host name for this replication source server. 

• PORT 

The port number for this replication source server. 

• NETWORK_NAMESPACE 

The network namespace for this replication source server. If this value is empty, connections use the default (global) namespace. 

• WEIGHT 

The priority of this replication source server in the replication channel’s source list. The weight is from 1 to 100, with 100 being the highest, and 50 being the default. When the asynchronous connection failover mechanism activates, the source with the highest weight setting among the alternative sources listed in the source list for the channel is chosen for the first connection attempt. If this attempt does not work, the 

