PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based replication. Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-drop-if-exists.html
IF EXISTS statements for stored programs (stored procedures and functions, triggers, and events) are also replicated, even if the stored program to be dropped does not exist on the source. The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
If the replica receives transactions from more than one source, as in the case of a diamond topology, the auto-skip function ensures that the transactions are not applied twice. GTIDs replace the file-offset pairs previously required to determine ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html
As with the method using empty transactions, this method creates a server that is functionally a snapshot, but in time is able to become a source as its binary log history converges with that of the replication source server or the group. There are ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html
For more information on how replication channels function, see Section 16.2.2, “Replication Channels”. MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel. In a multi-source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
It does not apply to stored procedures and functions, or events. This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
For example, in a typical scale-out scenario (see Section 16.3.4, “Using Replication for Scale-Out”), you want to use InnoDB tables on the source to take advantage of the transactional functionality, but use MyISAM on the replicas where ... It ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
Source 2 is the replica of Source 1 that provides the replication functionality to the remainder of the replicas in the replication structure. As the number of replicas connecting to a source increases, the load, although minimal, also increases, ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
Parameter markers can be used only where data values should appear, and they cannot be used for SQL keywords, identifiers, functions, and so on. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
A loadable function named load_rewrite_rules() is used by the flush_rewrite_rules() stored procedure. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them.