Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
However, at this point, you cannot distinguish whether a NULL represents a regular grouped value or a super-aggregate value. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time. The most common way to create a fault-tolerant system is to resort to making components redundant, in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
When you set a timeout, it also prevents new transactions starting on the primary from that point on. This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
For Group Replication, note the following key points and differences: The donor (an existing group member) and the recipient (the joining member) must have the clone plugin installed and active. If you want to use remote cloning operations for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
During state transfer from a donor's binary log, the joining member replicates and applies the required transactions from the donor's binary log, applying the transactions as they are received, up to the point where the binary log records that the ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server instance. The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group members. Incoming ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
At this point the member applies the policies for its new server version, which might have changed from the policies it applied when it originally joined the group. Group Replication is versioned according to the MySQL Server version that the Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-considerations.html
When upgrading an online group you should consider the following points: Regardless of the way which you upgrade your group, it is important to disable any writes to group members until they are ready to rejoin the group. When a member is stopped, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
At that point, servers exchange some of their metadata to synchronize themselves and continue to cooperate together. The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure.html
The responses of group members, including the failed member itself, to these situations can be configured at a number of points in the process. Group Replication's failure detection mechanism is designed to identify group members that are no longer ...