Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this function. If you do not want to use this function in a group, do not set it up, in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-ssl-for-recovery.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...Setting this option to ON is the equivalent for distributed recovery connections of setting VERIFY_IDENTITY for the group_replication_ssl_mode option for group communication ...Whether the distributed recovery connection is made using the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-securing.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...When a member joins the group, distributed recovery is carried out using a combination of a remote cloning operation, if available and appropriate, and an asynchronous replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group members. These options are normally set using a CHANGE REPLICATION SOURCE TO statement, but note that you cannot disable them for a Group Replication channel. The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
You could use the following statements to increase the compression threshold to 2MB, for example: STOP GROUP_REPLICATION; SET GLOBAL group_replication_compression_threshold = 2097152; START GROUP_REPLICATION; If you set ... For messages sent between ...
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/index-extensions.html
To check whether disabling use of index extensions can improve performance, use this statement: SET optimizer_switch = 'use_index_extensions=off'; Use of index extensions by the optimizer is subject to the usual limits on the number of key parts in ... InnoDB automatically extends each secondary index by appending the primary key columns to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-metrics-table.html
To start, stop, and reset counters, set one of the system variables innodb_monitor_enable, innodb_monitor_disable, innodb_monitor_reset, or innodb_monitor_reset_all, using the name of the counter, the name of the module, a wildcard match for such a ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-plugins-table.html
PLUGIN_STATUS The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED. The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_TYPE ...