PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
For a transaction to commit, the majority of the group have to agree on the order of a given transaction in the global sequence of transactions. These provide a failure detection mechanism, a group membership service, and safe and completely ordered ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
The second member joining the group needs to ask the member that bootstrapped the group to dynamically change the configuration in order for it to be added to the group. Why does Group Replication use two bind addresses? Group Replication uses two ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
A joining member must have its initial connection to the group permitted by the allowlist in order to retrieve the address or addresses for distributed recovery. Note It is possible to configure different allowlists on different group members ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
In order for a replication group to use fragmentation, all group members must be at MySQL 8.0.16 or above, and the Group Replication communication protocol version in use by the group must allow fragmentation. If all group members are at MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade.html
While you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. Depending on your group, the effects of these policies might ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
The optimizer cannot use a hash index to speed up ORDER BY operations. (This type of index cannot be used to search for the next entry in order.) MySQL cannot determine approximately how many rows there are between two values (this is used by the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
PARTITION_ORDINAL_POSITION All partitions are indexed in the same order as they are defined, with 1 being the number assigned to the first partition. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
SEQ A sequence number indicating the display order for rows with the same QUERY_ID value. For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 WITH CHECK OPTION; Then the view definition looks like this: SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 CHECK_OPTION The value of the ...You ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
In order for the progress indicator to be printed, the log file must be specified using the --log option. If the new checksum is identical to the existing checksum, the new checksum is not written to disk in order to minimize I/O. This tool reads an ...