PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. This approach works well if the total number of ...If it does, and some members have less write throughput than others—particularly less than the writer members—these members may start lagging behind the ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/start-group-replication.html
START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). If super_read_only=ON is ...For instructions to set up this account, see Section 20.2.1.3, “User Credentials For Distributed ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-securing.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 ...For a full description of distributed recovery, see Section 20.5.4, “Distributed ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus protocol. Among other functions, the message cache is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
The group_replication_autorejoin_tries system variable, which is available from MySQL 8.0.16, makes a member that has been expelled or reached its unreachable majority timeout try to rejoin the group automatically. From MySQL 8.0.21, the value of ...Up to MySQL 8.0.20, the value of the system variable defaults to 0, so auto-rejoin is not activated by ...