Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binary logging is disabled on the server, or if statements are not written to the binary log because they are removed by a filter, GTID consistency is not checked or enforced for the statements that are not logged. Because GTID-based replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterstatus.html
If the source has been running previously with binary logging disabled, the log file name and position values displayed by SHOW BINARY LOG STATUS or mysqldump --source-data are empty. To configure the replica to start the replication process at the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
The REPLICATION_APPLIER privilege explicitly or implicitly allows the PRIVILEGE_CHECKS_USER account to carry out the following operations that a replication thread needs to perform: Setting the value of the system variables gtid_next, ... The user ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
For example: mysql> STOP GROUP_REPLICATION; mysql> CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'gr_repl'@'%.example.com' FOR CHANNEL 'group_replication_recovery'; mysql> FLUSH PRIVILEGES; mysql> START GROUP_REPLICATION; For Group ... You ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
After a semisynchronous replication plugin has been installed, it is disabled by default. Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
To enable or disable the plugin, set this variable to 1 or 0, respectively. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous Replication”), system variables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
If semisynchronous replication is disabled on the source, or enabled on the source but on no replicas, the source uses asynchronous replication. In addition to the built-in asynchronous replication, MySQL 8.4 supports an interface to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
If your replicas are not acting as sources, and you have a potential solution in place to ensure that you can bring up a source in the event of failure, then you can disable log_replica_updates. As the number of replicas connecting to a source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
MySQL Server performs the entire MySQL upgrade procedure automatically, disabling binary logging during the upgrade. When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
Note If installed, the Rewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script ...