PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
For full instructions to configure and start sources and replicas using GTID-based replication, see Section 16.1.3.4, “Setting Up Replication Using GTIDs”. GTIDs replace the file-offset pairs previously required to determine points for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-binlog-master.html
These steps assume that you have enabled binary logging on the replication source server using --log-bin, the replica is using TABLE based replication metadata repositories, and that you have enabled a replication user and noted the current binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the replication source servers using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication metadata repositories, and provisioned the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-reset-replica.html
For the full syntax of the RESET SLAVE command and other available options, see Section 13.4.2.3, “RESET SLAVE Statement”. The RESET SLAVE statement can be used to reset a multi-source replica. By default, if you use the RESET SLAVE statement ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-start-replica.html
For example, to start the two channels separately, use the mysql client to issue the following statements: mysql> START SLAVE FOR CHANNEL "source_1"; mysql> START SLAVE FOR CHANNEL "source_2"; For the full syntax of the START SLAVE command and other ... Once you have added channels for all of the sources, issue a START SLAVE statement to start ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-stop-replica.html
To stop all currently configured replication channels: STOP SLAVE; To stop only a named channel, use a FOR CHANNEL channel clause: STOP SLAVE FOR CHANNEL "source_1"; For the full syntax of the STOP SLAVE command and other available options, see ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
With row-based replication, the replica only has to modify the affected rows, not execute the full statement. For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want ...