Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
When a replica has GTIDs enabled (GTID_MODE=ON, ON_PERMISSIVE, or OFF_PERMISSIVE ) and the SOURCE_AUTO_POSITION option enabled, auto-positioning is activated for connection to the source. The source must have GTID_MODE=ON set in order for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
If you are starting with new servers, see Section 19.1.2.3, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 19.1.2.1, “Setting the Replication Source Configuration” for ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Each replica that connects to the source requests a copy of the binary log. Because each replica is independent, the replaying of the changes from the source's binary log occurs independently on each replica that is connected to the source.
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. To monitor the connection status of a named channel, use a WHERE CHANNEL_NAME=channel clause: mysql> SELECT * FROM ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
If the server ID is set to 0, binary logging takes place, but a source with a server ID of 0 refuses any connections from replicas, and a replica with a server ID of 0 refuses to connect to a source. The following sections contain information about ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
If you want to be able to restore the data and operate as a replica (for example, in the event of failure of the replica), in addition to the data, you need to have the replica's connection metadata repository and applier metadata repository, and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
Web clients that issue only reads (and would normally be connected to the replicas) are not shown, as they do not need to switch to a new server in the event of failure. To use CHANGE REPLICATION SOURCE TO, add all information about how to connect ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it ... MySQL replication capabilities are implemented using the following types of threads: Binary log dump ...