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/replication-solutions-switch.html
If you are not using GTIDs for replication, then the replicas should also be run with --log-slave-updates=OFF (logging replica updates is the default). Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary logging ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. This causes the replica to be out of synchrony with the source and ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and PROCEDURE. The WITH CHECK OPTION clause can be given to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. Updates to the applier metadata repository are committed ...This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
A member applies these policies to decide whether to join the group normally, or join in read-only mode, or not join the group, depending on which choice results in the safe operation of the joining member and of the existing members of the group.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...If you do not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
They do not apply to tables that are implicitly updated by the query. For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
However, because the file positions are not being regularly updated in the connection metadata repository and the applier metadata repository except in a few situations, they are likely to be out of date if the server is restarted. When the receiver ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--auto-generate-sql-load-type=type Command-Line Format --auto-generate-sql-load-type=type Type Enumeration Default Value mixed Valid Values readwritekeyupdatemixed Specify the test load type. The permissible values are read (scan tables), write ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. To update cached ...