PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/8.0/en/security.html
Ensure that you have adequate and appropriate backups of your database files, configuration and log files. Also be sure that you have a recovery solution in place and test that you are able to successfully recover the information from your backups.