Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Issue SELECT * FROM performance_schema.replication_group_members and compare the initial group size and the new group size. Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
If you are considering reducing the cache size limit, you can query the Performance Schema table memory_summary_global_by_event_name using the following statement: SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME ... The minimum setting for the XCom message cache size in MySQL 8.4 is 128 MB, which enables deployment on a host that has a restricted amount of available ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache.html
The same cache size limit should be set on all group members, because an unreachable member that is attempting to reconnect selects any other member at random for recovery of missed messages. The group communication engine for Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-member-stats.html
To use this table to monitor a Group Replication member, issue the following statement: mysql> SELECT * FROM performance_schema.replication_group_member_stats\G You can also use the following statement: mysql> TABLE ... Each member in a replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are members of the group. The information in the table is updated whenever there is a view change, for example when the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
Use group_replication_recovery_tls_version and group_replication_recovery_tls_ciphersuites to configure client support for any selection of ciphersuites, including only non-default ciphersuites if desired. Secure sockets can be used for group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-consensus-leader.html
The Performance Schema table replication_group_communication_information shows the current preferred and actual consensus leader, with the preferred leader being Group Replication’s choice, and the actual leader being the one selected by the group ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
For example: mysql> SELECT MEMBER_HOST, MEMBER_ROLE FROM performance_schema.replication_group_members; +-------------------------+-------------+ | MEMBER_HOST | MEMBER_ROLE | +-------------------------+-------------+ | remote1.example.com | PRIMARY ... In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
Meanwhile, the joining member selects a suitable donor from the list of online servers as stated by the membership service through the view abstraction. When Group Replication's distributed recovery process is carrying out state transfer from the ...