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-features-create-if-not-exists.html
If the statement includes IF NOT EXISTS, it is considered successful, and is logged as long as at least one user named in the statement is created; in such cases, the statement is logged as written; this includes references to existing users that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
This includes the case that the destination table exists and IF NOT EXISTS is not given. If the destination table exists and IF NOT EXISTS is given, MySQL 8.0 ignores the statement completely; nothing is inserted or logged. SELECT always performs an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
However, statements that would normally update this information indirectly—such GRANT, REVOKE, and statements manipulating triggers, stored routines, and views—are replicated to replicas using statement-based replication. Data modification ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
For a full list of options, and information about the maximum permissible length for the string-valued options, see Section 15.4.2.1, “CHANGE MASTER TO Statement”. To set up the replica to communicate with the source for replication, configure ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-reset-replica.html
RESET REPLICA makes the replica forget its replication position, and clears the relay log, but it does not change any replication connection parameters (such as the source host name) or replication filters. For the full syntax of the RESET REPLICA ... The RESET REPLICA statement can be used to reset a multi-source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-start-replica.html
Once you have added channels for all of the replication sources, issue a START REPLICA (or before MySQL 8.0.22, START SLAVE) statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-statements-replica.html
In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For information about these statements, see Section 15.7.7.35, “SHOW REPLICA STATUS Statement”, and Section 15.7.7.32, ...
https://dev.mysql.com/doc/refman/8.0/en/reset-slave.html
From MySQL 8.0.22, RESET SLAVE is deprecated and the alias RESET REPLICA should be used instead. The statement works in the same way as before, only the terminology used for the statement and its output has changed. Both versions of the statement ...
https://dev.mysql.com/doc/refman/8.0/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Also resets the relay log ...reset_option: { MASTER | REPLICA | SLAVE } The RESET statement is used to clear the state of various server ...
https://dev.mysql.com/doc/refman/8.0/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...