Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade-with-mysqlbackup.html
Repeat this process to create a suitable number of new instances, for example to be able to handle a failover. As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
The randomly generated part is generated when the group is created, and remains unchanged while there is at least one member in the group. When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
The server handles entries in the host cache like this: When the first TCP client connection reaches the server from a given IP address, a new cache entry is created to record the client IP, host name, and client lookup validation flag. The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
ICP is not supported with secondary indexes created on virtual generated columns. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the ...
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/information-schema-check-constraints-table.html
CREATE TABLE supports the core features of table and column CHECK constraints; the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. You can cause such information to be hidden by setting show_gipk_in_create_table_and_information_schema = OFF. The related ST_GEOMETRY_COLUMNS ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The ...