PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
By default, source and replica servers assume that they are in the same time zone. If you are replicating between servers in different time zones, the time zone must be set on both source and replica. Otherwise, statements depending on the local ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html
This section explains transaction-based replication using global transaction identifiers (GTIDs). Because GTID-based replication is completely transaction-based, it is simple to determine whether sources and replicas are consistent; as long as all ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html
A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them available. After a plugin has been installed, you control it by means of the system variables associated with it. These system ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups.html
To use replication as a backup solution, replicate data from the source to a replica, and then back up the replica. The replica can be paused and shut down without affecting the running operation of the source, so you can produce an effective ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions.html
Replication can be used in many different environments for a range of purposes. This section provides general notes and advice on using replication for specific solution types. For information on using replication in a backup environment, including ...
https://dev.mysql.com/doc/refman/5.7/en/replication-statements-master.html
Section 13.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding replication. For information on source states, see Section 8.14.5, “Replication Source Thread States”. For replica ...