Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values that don't conflict with other servers. Why did MySQL version numbering skip versions 6 and 7 and go straight to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-upgrade.html
During an online upgrade procedure, if the group is in single-primary mode, all the servers that are not currently offline for upgrading function as they did before. The group elects a new primary whenever necessary, following the election policies ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
The AFTER consistency level has no impact on read-only transactions, because they do not generate changes. Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
View change events (View_change_log_event), which are generated by the group itself when a new member joins, are given GTIDs when they are recorded in the binary log. Group Replication uses GTIDs (global transaction identifiers) to track exactly ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
When checksums are available, Group Replication does not use them to verify incoming events on the group_replication_applier channel, because events are written to that relay log from multiple sources and before they are actually written to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with ...In other words servers with a newer version can join the group only as ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
For example, a statement could generate multiple warnings with different error codes, for each of which an error-specific handler exists. A stored program may include handlers to be invoked when certain conditions occur within the program. The ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
This means that you can force a table's statistics to be regenerated with a given method without affecting other clients by setting the session value of myisam_stats_method. There is no way to tell which method was used to generate statistics for a ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
Including MySQL NDB Cluster 8.4 Abstract This is the MySQL Reference Manual. It documents MySQL 8.4 through 8.4.6, as well as NDB Cluster 8.4 through 8.4.6, respectively. It may include documentation of features of MySQL versions that have not yet ...