Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
Note You can use the SOURCE_TLS_CIPHERSUITES option to specify any selection of ciphersuites, including only non-default ciphersuites if you want. To use an encrypted connection for the transfer of the binary log required during replication, both ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-limit.html
SELECT statements is unsafe since the order of the rows affected is not defined. Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
SELECT FROM memory_table may insert a different set of rows on the source and replica. When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
This GTID set is equal to the union of the set of GTIDs in the gtid_executed system variable (@@GLOBAL.gtid_executed), and the set of GTIDs recorded in the Performance Schema replication_connection_status table as received transactions (the result ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
This thread is not listed in the output of SHOW PROCESSLIST, but it can be viewed as a row in the threads table, as shown here: mysql> SELECT * FROM performance_schema.threads WHERE NAME LIKE '%gtid%'\G *************************** 1. A global ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
After configuring the basic options, select your scenario: To set up replication for a fresh installation of a source and replicas that contain no data, see Section 19.1.2.6.1, “Setting Up Replication with New Source and Replicas”. This section ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Typically, SELECT statements are not recorded because they modify neither database structure nor content. Replication is based on the 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/8.4/en/replication-mode-change-online-disable-gtids.html
This can be checked using the statement shown here: SELECT @@global.gtid_owned; On a replica, it is theoretically possible that this is empty and then becomes nonempty again. This section describes how to disable GTID transactions on servers that ...