PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterbaseconfig.html
Note that if a value of 0 (which was the default in earlier releases) was set previously for the server ID, you must restart the server to initialize the source with your new nonzero server ID. Note The following options also have an impact on the ... To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ...
https://dev.mysql.com/doc/refman/8.0/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. You must be able to connect to the source MySQL server using TCP/IP. The CHANGE REPLICATION SOURCE TO | CHANGE ...
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 ...