Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
All group members receive the current source list as recorded in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables. Asynchronous connection failover for replicas is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) replication connection to a new source automatically, after the existing connection from a replica to its source fails. The asynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a repeatable test case that demonstrates the bug, please enter it into ...We need to obtain as much information as possible from you to be able to track down the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only need the replica to replicate it from one source. In MySQL multi-source replication, a replica opens multiple replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql schema are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
Table 14.28 Positional Synchronization Functions Name Description Deprecated MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position Yes SOURCE_POS_WAIT() Block until the replica has read and applied ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
The Performance Schema replication_applier_configuration table shows whether GTIDs are assigned to anonymous transactions on a replication channel, what the UUID is, and whether it is the UUID of the replica server (LOCAL) or a user-specified UUID ... You can set up replication channels to assign a GTID to replicated transactions that do not already have ...
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-failover.html
This method is simple and effective, but requires the replica to read the binary log from the source; it can sometimes take a comparatively long time for the new replica to catch up with the source, so this method is not suitable for fast failover ... There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for ...