Search Results
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 ...For detailed instructions to set up this user, see Section 20.2.1.3, “User Credentials For Distributed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
The tp_thread_group_state table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The tp_thread_group_state table has these columns: TP_GROUP_ID The thread group ID. This is where ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-message-fragmentation.html
When an abnormally large message is sent between Group Replication group members, it can result in some group members being reported as failed and expelled from the group. This is because the single thread used by Group Replication's group ...By ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-fault.html
Group Replication's distributed recovery process has a number of built-in measures to ensure fault tolerance in the event of any problems during the process. The donor for distributed recovery is selected randomly from the existing list of suitable ...For state transfer from the binary log, the joiner selects a donor that is running a lower or equal patch version of MySQL Server compared to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
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 super_read_only=ON). All other servers that ...The following diagram shows this process: Figure 20.4 New Primary Election When a new primary is chosen, it might have a backlog of changes that had been applied on the old primary but have not yet been applied on the new ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
For messages sent between online group members, Group Replication enables message compression by default. Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...Messages that have a payload larger than the specified number of bytes are ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
By default, members that find themselves in a minority due to a network partition do not automatically leave the group. You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait ...This feature is active by default; the member makes three auto-rejoin ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-instruments.html
The MySQL Performance Schema provides instrumentation for performance monitoring of Group Replication memory usage. The memory/group_rpl/ Performance Schema instrumentation contains the following instruments: write_set_encoded: Memory allocated to ...Gcs_message_data::m_buffer: Memory allocated for the transaction data payload sent to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
You can also use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. The group_replication_applier thread on each group member is used for applying group transactions, and the ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while ...