Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-membership.html
If a server joins the group, it automatically brings itself up to date by fetching the missing state from an existing server. In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
Expelled members automatically attempt to rejoin the group, and are brought up to date by distributed recovery. Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated recovery. If a member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-member-stats.html
This means that the member is delayed and is not able to keep up to date with the other members of the group. Each member in a replication group certifies and applies transactions received by the group. Statistics regarding the certifier and ...
https://dev.mysql.com/doc/refman/8.4/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. There is no need for server failover, and the multi-source update everywhere nature ensures that even updates are not ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. For optimizer purposes, an important statistic is the average ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Similarly, deletes and updates may affect secondary index pages that ...