PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
Note It is crucial that you complete every step before continuing to the next step. This can be checked using: SHOW STATUS LIKE 'ONGOING_ANONYMOUS_TRANSACTION_COUNT'; Note On a replica, it is theoretically possible that this shows zero and then ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
Also note that for MySQL 5.6 and 5.7, this limitation means all the dump files from the sources must be applied in a single operation on a replica with an empty gtid_executed set. If the sources in the multi-source replication topology have ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
Note Statement-based replication stops if a single SQL statement operates on both a table that is included by a --replicate-do-table or --replicate-wild-do-table option, and another table that is ignored by a --replicate-ignore-table or ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules.html
Note that replication filters cannot be used on Group Replication-specific channels on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
Note If the replication source server or existing replica that you are copying to create the new replica has any scheduled events, ensure that these are disabled on the new replica before you start it. Note The contents of the replica's connection ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
Note that although this setting is the safest, it is also the slowest due to the number of disk writes involved. Note that this setting ignores the existing relay log files, in case they are corrupted or inconsistent. In order for replication to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions.html
This section provides general notes and advice on using replication for specific solution types. For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, ... Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
For notes and tips on how different data types and statements are treated during replication, including details of replication features, version compatibility, upgrades, and potential problems and their resolution, see Section 19.5, “Replication ... Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as ...
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
Note This statement is replaced in later versions of MySQL by RESET BINARY LOGS AND GTIDS, and should be considered deprecated. Note that RESET MASTER is the method to reset the GTID execution history even if the GTID-enabled server is a replica ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
Note All relay log files are deleted, even if they have not been completely executed by the replication SQL thread. Note When used on an NDB Cluster replica SQL node, RESET REPLICA clears the mysql.ndb_apply_status table. RESET REPLICA [ALL] ...