Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
The performance and stability of a group can be impacted by both network latency and network bandwidth. Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Transactions are executed optimistically and then, at commit time, are checked for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
This exit action prevents both updates and stale reads (with the exception of reads by client users with the stated privileges), and enables proxy tools such as MySQL Router to recognize that the server is unavailable and redirect client connections. The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure.html
In this situation, the default behavior is for the members in both the minority and the majority to remain in the group, continue to accept transactions (although they are blocked on the members in the minority), and wait for operator intervention.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
Each member's connections to other existing members continue to use the highest available protocol that both members support. Secure sockets can be used for group communication connections between members of a group. The Group Replication system ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The same replication user is used for distributed recovery on all the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-consensus-leader.html
In this situation, the Performance Schema table replication_group_communication_information shows all of the members as both the preferred and actual leaders. By default, the group communication engine for Group Replication (XCom, a Paxos variant) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
For example, if t1 and t2 execute concurrently at different sites, both changing the same row, and t2 is ordered before t1, then t2 wins the conflict and t1 is rolled back. Group Replication is a technique that can be used to implement ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
Data flow operations apply to both modes of Group Replication: single-primary and multi-primary, however to make this explanation clearer it is restricted to single-primary mode. In terms of distributed consistency guarantees, either in normal or ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.