Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
Group Replication uses a distributed recovery process to synchronize group members when joining them to the group. Distributed recovery involves transferring transactions from a donor's binary log to a joining member using a replication channel ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be confused with the member's internal group communication address ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration setting, specified by the group_replication_single_primary_mode system variable, which must be the same on all members. It is not possible to have members of the group deployed in different modes, for example one member configured in multi-primary mode while another member is in single-primary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-ssl-for-recovery.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...If the server you connect to does not use the default configuration for this (see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”), use the other distributed recovery SSL options to determine which certificates and cipher suites to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the group. When this is done, the current primary becomes a ...You can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-upgrade.html
During an online upgrade procedure, if the group is in single-primary mode, all the servers that are not currently offline for upgrading function as they did before. The group elects a new primary whenever necessary, following the election policies ...Note that if you require the primary to remain the same throughout (except when it is being upgraded itself), you must first upgrade all of the secondaries to a version higher than or equal to the target primary member version, then upgrade the primary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-tuning-recovery.html
Several aspects of Group Replication's distributed recovery process can be configured to suit your system. Number of Connection Attempts For state transfer from the binary log, Group Replication limits the number of attempts a joining member makes ...If the connection retry limit is reached without a successful connection, the distributed recovery procedure terminates with an ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-resource-groups-table.html
The RESOURCE_GROUPS table provides access to information about resource groups. For general discussion of the resource group capability, see Section 7.1.16, “Resource Groups”. The RESOURCE_GROUPS table has these columns: RESOURCE_GROUP_NAME The ...You can see information only for columns for which you have some ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-stats-table.html
The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a different value for each member in the group. This also serves as a key because ...