PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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. The replica does not check whether the databases on the source are ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/reusing-ssl-sessions.html
If the currently active mysql connection did resume the session, the status information includes SSL session reused: true. MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache.
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.