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-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
This is also true of the relay log index file if the relay_log_index system variable is not used. You can add another replica to an existing replication configuration without stopping the source server. To do this, you can set up the new replica by ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
With this option set to 1 (TRUE), the replica does not skip events that have its own server ID. This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
With this option, replication instructions from Source 1 are also written to Source 2's binary log so that they can then be replicated to the true replicas. As the number of replicas connecting to a source increases, the load, although minimal, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
When this is true for all replicas, they can be reconfigured to the new setup. 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 TO. The replica does not check ...
https://dev.mysql.com/doc/refman/8.0/en/restart.html
One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
If the currently active mysql connection did resume the session, the status information includes SSL session reused: true. As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session ...