PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-blackhole.html
For this reason we recommend when you replicate to tables using the BLACKHOLE storage engine that you have the binlog_format server variable set to STATEMENT, and not to either ROW or MIXED. The BLACKHOLE storage engine accepts data but discards it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
This can cause problems if no corresponding directory exists in the replica host's file system or if it exists but is not accessible to the replica server. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
An example of this is using a table column named virtual on a 5.6 source that is replicating to a 5.7 or higher replica because VIRTUAL is a reserved word beginning in MySQL 5.7. You can encounter problems when you attempt to replicate from an ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-sql-mode.html
This advice applies whether you are using statement-based or row-based replication. At a minimum, this is likely to cause the distribution of data among partitions to be different in the source's and replica's copies of a given table. Using ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Any account can be used for this operation, providing it has been granted the REPLICATION SLAVE privilege. To grant this account the privileges required for replication, use the GRANT statement. Each replica connects to the source using a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions.
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
This means that you must select the default database explicitly with a USE statement in order for a DDL statement to be applied. Important A statement that is still permitted at this stage is not yet actually executed. When evaluating replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
Database-level options (--replicate-do-db, --replicate-ignore-db) are checked first; see Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”, for a description of this process. This is a change in behavior ...