PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-members.html
The information in the table is updated whenever there is a view change, for example when the configuration of the group is dynamically changed when a new member joins. The performance_schema.replication_group_members table is used for monitoring ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can use group_replication_autorejoin_tries, which is available from MySQL 8.0.16, to make the member automatically try to rejoin the group at this point. From MySQL 8.0.21, this feature is activated by default and the member makes three ... You ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
All other servers that join the group learn about the primary server and are automatically set to read-only mode. In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write mode. All the other members in the group are set to read-only mode (with ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
For Group Replication, the control operations that can be evaluated in terms of consistency are: a member joining or leaving, which is covered by Group Replication's Section 20.5.4, “Distributed Recovery” and write protection. In terms of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade-with-mysqlbackup.html
Then join the instances to a group based on the Section 20.8.3.3, “Group Replication Online Upgrade Methods”.` . As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
There is a distributed recovery procedure to ensure that when servers join the group they are brought up to date automatically. Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
Servers can leave and join the group and the view is updated accordingly. This chapter explains MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
The union of two GTID sets is simply their representations as strings, joined together with an interposed comma. The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
The optimizer can use extended secondary indexes for ref, range, and index_merge index access, for Loose Index Scan access, for join and sorting optimization, and for MIN()/MAX() optimization. InnoDB automatically extends each secondary index by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...