Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
To test how the system behaves when there is a lag. MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. This section describes how to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To be able to connect, the replica must have at least one TLS version in common with the source. For example: mysql> CREATE USER 'repl'@'%.example.com' IDENTIFIED BY 'password' -> REQUIRE SSL; mysql> GRANT REPLICATION SLAVE ON *.* -> TO ... To use ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4, 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.4/en/replication-functions-synchronization.html
If binary log transaction compression is in use and the transaction payload at the specified position is compressed (as a Transaction_payload_event), the function waits until the whole transaction has been read and applied, and the positions have ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/replication-privilege-checks-gr.html
Group Replication requires every table that is to be replicated by the group to have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. For this reason, new and upgraded Group Replication channels have ...