Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that failover is required, and a backup taken from the replica cannot be used to restore ... 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-lifecycle.html
It is important to note that the replica sets gtid_next in a session context. The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. This client transaction is assigned a GTID composed of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
Important Before copying, verify that all the files relating to the existing replica actually are stored in the data directory. You can add another replica to an existing replication configuration without stopping the source server. To do this, you ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-repuser.html
Important To connect to the source using a user account that authenticates with the caching_sha2_password plugin, you must either set up a secure connection as described in Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”, ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slaveinit.html
To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
Important The maximum number of GTIDs available on a given server instance is equal to the number of non-negative values for a signed 64-bit integer (263 - 1). The MySQL Server system variables described in this section are used to monitor and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
Important The caching_sha2_password authentication plugin is the default for new users (for details, see Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”). By default, MySQL replication (including Group Replication) does not carry out ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
Important Table-level replication filters are only applied to tables that are explicitly mentioned and operated on in the query. The replica checks for and evaluates table options only if either of the following two conditions is true: No matching ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Important With semisynchronous replication, if the source crashes and a failover to a replica is carried out, the failed source should not be reused as the replication source, and should be discarded. In addition to the built-in asynchronous ...