PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.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/5.7/en/replication-features-limit.html
Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-optimizer.html
(In general, this is not a good practice, even outside of replication.) Examples of nondeterministic statements include DELETE or UPDATE statements that use LIMIT with no ORDER BY clause; see Section 16.4.1.17, “Replication and LIMIT”, for a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure except where an exception is specifically allowed (see Section 16.4.1.10, “Replication with Differing Table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-truncate.html
However this caused issues when logging or replicating, in STATEMENT or MIXED mode, tables that used transactional storage engines such as InnoDB when the transaction isolation level was READ COMMITTED or READ UNCOMMITTED, which precludes ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-user-names.html
However, this should occur only when replicating from a newer source to an older replica, which is not a recommended configuration. The maximum length of MySQL user names was increased from 16 characters to 32 characters in MySQL 5.7.8. Replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-views.html
This means that a view can be replicated to the replica even if the view contains a table that would normally be filtered out by replication-ignore-table rules. Views are filtered by their own name, not by the tables they refer to. Care should ...
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
This has the effect of repeating the original changes just as they were made on the source. Replication is based on the replication source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online.html
This section describes how to change the mode of replication being used without having to take the server offline.
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-binlog-master.html
These steps assume that you have enabled binary logging on the replication source server using --log-bin, the replica is using TABLE based replication metadata repositories, and that you have enabled a replication user and noted the current binary ...