PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-shutdowns.html
However, the replica notices the network outage only after receiving no data from the source for replica_net_timeout seconds. If your outages are short, you may want to decrease the value of replica_net_timeout. Setting sync_relay_log_info to 0 ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-enable-gtids.html
The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 19.1.4.3, “Disabling GTID Transactions Online”, the online procedure to disable GTIDs. If you use ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. The statement can therefore potentially be left in the dump output when you ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-recover.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. If a privilege check against the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-safe-unsafe.html
Whenever the 50 most recent ER_BINLOG_UNSAFE_STATEMENT warnings have been generated more than 50 times in any 50-second period, warning suppression is enabled. When activated, this causes such warnings not to be written to the error log; instead, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-semisync-interface.html
rpl_semi_sync_source_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. The replication characteristics of these settings ... When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous Replication”), system variables become available to control plugin ...
https://dev.mysql.com/doc/refman/9.7/en/replication-semisync.html
Fully synchronous replication means failover from the source to any replica is possible at any time. The amount of slowdown is at least the TCP/IP roundtrip time to send the commit to the replica and wait for the acknowledgment of receipt by the ...
https://dev.mysql.com/doc/refman/9.7/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. This global variable defaults to OFF and is read-only at ...This ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_reloads The number of times the rewrite_rules table has been loaded into the in-memory cache used by the Rewriter plugin. Rewriter_reload_error Whether an error occurred the most recent time that the rewrite_rules table was loaded ...