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-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.0/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 is 1 GB up to MySQL ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 Beginning with MySQL 8.0.19, you can also use the following statement: mysql> TABLE ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/group-replication-secure-socket-layer-support-ssl.html
From MySQL 8.0.19, you can use the options to configure client support for any selection of ciphersuites, including only non-default ciphersuites if you want. Secure sockets can be used for group communication connections between members of a group. The Group Replication system variable group_replication_ssl_mode is used to activate the use of SSL for group communication connections and specify the security mode for the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...