Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
If the issue is only missing transactions on the source, you can make the source into a replica instead, allow it to catch up with the other servers in the replication topology, and then make it a source again if needed. GTIDs replace the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
Copy the contents of the existing replica's relay log index file into the new replica's relay log index file, making sure to overwrite any content already in the file. You can add another replica to an existing replication configuration without ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
For example: sed '/GTID_PURGED/d' dumpM1.sql > dumpM1_nopurge.sql sed '/GTID_PURGED/d' dumpM2.sql > dumpM2_nopurge.sql Use the mysql client to import each edited dump file into the replica. If the sources in the multi-source replication topology ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
When many rows are affected, the set of changes is split into several events; when the statement commits, all of these events are written to the binary log. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
If you configure multiple rewrite-db=from_name->to_name options with the same from_name database, all filters are added together (put into the rewrite_do list) and the first one takes effect. This section explains how to work with replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
This prevents “dumb” replicas from also logging events they have executed into their own binary log. As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
The current progress of the replication applier (SQL) thread when using row-based replication is monitored through Performance Schema instrument stages, enabling you to track the processing of operations and check the amount of work completed and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions.html
For guidance on switching sources, or converting replicas into sources as part of an emergency failover solution, see Section 19.4.8, “Switching Sources During Failover”. Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
These cause the output of cat to be substituted into the kill command. If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section ...