PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...
https://dev.mysql.com/doc/refman/8.0/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 19.5.1.9, “Replication with Differing Table ...DROP PARTITION) that act directly on partitions in such cases might produce different results on the source and the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. You can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet ... In MySQL 8.0, when binlog_format is set to ROW or MIXED, statements that exclusively use temporary tables are not logged on the source, and therefore the temporary tables are not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
ON: All transaction must have GTIDs; anonymous transactions cannot be replicated. It is possible to have servers using anonymous and servers using GTID transactions in the same replication topology. Before setting the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
You cannot have both the new and the old version of the relevant plugin installed on an instance. In the event of source failure, all transactions committed on the source have been replicated to the replica (saved to its relay log). When you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-monitoring.html
You cannot have both the new and the old version of the relevant plugin installed on an instance. Automatic fallback from semisynchronous to asynchronous replication on the source means that it is possible for the rpl_semi_sync_source_enabled or ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
You must invoke flush_rewrite_rules() to load the table contents into the plugin in-memory cache: mysql> CALL query_rewrite.flush_rewrite_rules(); Tip If your rewrite rules seem not to be working properly, make sure that you have reloaded the rules ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...