Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
PDF (RPM) - 39.7Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 244.2Kb
Man Pages (Zip) - 349.3Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The replication_asynchronous_connection_failover Table

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 UDFs to add and remove replication source servers from the source list for a replication channel.

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 priority 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 priority 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 replica tries with all the listed sources in descending order of priority, then starts again from the highest priority source. If multiple sources have the same priority, the replica orders them randomly.

The replication_asynchronous_connection_failover table has these indexes:

  • Primary key on (CHANNEL_NAME, HOST, PORT, NETWORK_NAMESPACE )

TRUNCATE TABLE is not permitted for the replication_asynchronous_connection_failover table.