PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
When this is done, the current primary becomes a read-only secondary, and the specified group member becomes the read-write primary; this replaces the usual primary election process as described in Section 20.1.3.1, “Single-Primary Mode”. As of ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
However, if a second server fails involuntarily, then the group (with one server left) blocks, because there is no majority to reach a decision. MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
A few seconds after this, looking again at the replication_group_members table on s1 shows that it is still online, but several others members are not. The group needs to achieve consensus whenever a change that needs to be replicated happens. This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-increase.html
In this situation, consider increasing the group_replication_message_cache_size limit with reference to the expected volume of messages in the time period specified by the group_replication_member_expel_timeout system variable plus the 5-second ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
The information is shared every second, and this period is sufficient to address both concerns. The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and throughput. It then ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait after losing contact with the majority of group members, and then exit the group. By default, members that find ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
When a new primary server is elected (automatically or manually), it is automatically set to read/write, and the other group members remain as secondaries, and as such, read-only. If more than one member is running the lowest MySQL Server version, ... 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-summary.html
The conflict resolution procedure states that the transaction that was ordered first commits on all servers, and the transaction ordered second aborts, and is therefore rolled back on the originating server and dropped by the other servers in the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
With the second alternative, the system secures a stable group membership after the primary failure and elects a new primary in the same way as the first alternative, but in this case the group then waits until the new primary applies all backlog ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...