Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.0Mb
PDF (A4) - 41.1Mb
PDF (RPM) - 39.5Mb
HTML Download (TGZ) - 9.3Mb
HTML Download (Zip) - 9.3Mb
HTML Download (RPM) - 7.9Mb
Man Pages (TGZ) - 260.6Kb
Man Pages (Zip) - 371.7Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

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

27.12.11.4 The replication_asynchronous_connection_failover_managed Table

This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including Group Replication topologies.

When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members automatically as they join or leave. The asynchronous connection failover mechanism fails over the connection if another available server on the source list has a higher priority (weight) setting. For a managed group, a source’s weight is assigned depending on whether it is a primary or a secondary server. So assuming that you set up the managed group to give a higher weight to a primary and a lower weight to a secondary, when the primary changes, the higher weight is assigned to the new primary, so the replica changes over the connection to it. The asynchronous connection failover mechanism additionally changes connection if the currently connected managed source server leaves the managed group, or is no longer in the majority in the managed group. For more information, see Section 17.4.9, “Switching Sources with Asynchronous Connection Failover”.

The replication_asynchronous_connection_failover_managed table has these columns:

  • CHANNEL_NAME

    The replication channel where the servers for this managed group operate.

  • MANAGED_NAME

    The identifier for the managed group. For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable.

  • MANAGED_TYPE

    The type of managed service that the asynchronous connection failover mechanism provides for this group. The only value currently available is GroupReplication.

  • CONFIGURATION

    The configuration information for this managed group. For the GroupReplication managed service, the configuration shows the weights assigned to the group's primary server and to the group's secondary servers.

The replication_asynchronous_connection_failover_managed table has these indexes:

  • Primary key on (CHANNEL_NAME, MANAGED_NAME)

TRUNCATE TABLE is not permitted for the replication_asynchronous_connection_failover_managed table.