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-administration-status.html
A value of 0 for Seconds_Behind_Source can usually be interpreted as meaning that the replica has caught up with the source, but there are some cases where this is not strictly true. The most common task when managing a replication process is to ...
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption-encryption-keys.html
The format of binary log encryption keys in the keyring is as follows: MySQLReplicationKey_{UUID}_{SEQ_NO} For example: MySQLReplicationKey_00508583-b5ce-11e8-a6a5-0010e0734796_1 {UUID} is the true UUID generated by the MySQL server (the value of ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
(This is true even if both tables have the same number of columns.) Columns common to both versions of the table must be defined before any additional columns. Source and target tables for replication do not have to be identical. A table on the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-floatvalues.html
This is true for operations that use floating-point values explicitly, or that use values that are converted to floating-point implicitly. With statement-based replication, values are converted from decimal to binary. Because conversions between ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
(See also Section 19.5.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and RAND(). Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transaction-inconsistencies.html
This remains true even if START REPLICA is used with UNTIL. Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication configuration. This section explains how to avoid ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transactions.html
This is even true for statements affecting tables that use a nontransactional storage engine (such as MyISAM). In MySQL 9.6 (and later), transactions that update both transactional tables and tables which are nontransactional or noncomposable are ...
https://dev.mysql.com/doc/refman/9.7/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/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 ...