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-gtids-concepts.html
This thread is not listed in the output of SHOW PROCESSLIST, but it can be viewed as a row in the threads table, as shown here: mysql> SELECT * FROM performance_schema.threads WHERE NAME LIKE '%gtid%'\G *************************** 1. A global ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
Other than that, how you organize and select the server IDs is your choice, so long as each server ID is different from every other server ID in use by any other server in the replication topology. To configure a source to use binary log file ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
After configuring the basic options, select your scenario: To set up replication for a fresh installation of a source and replicas that contain no data, see Section 16.1.2.5.3, “Setting Up Replication between a New Source and Replicas”. This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
Typically, SELECT statements are not recorded because they modify neither database structure nor content. Replication is based on the replication source server keeping track of all changes to its databases (updates, deletes, and so on) in its ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
This can be checked using: SELECT @@GLOBAL.GTID_OWNED; On a replica, it is theoretically possible that this is empty and then nonempty again. This section describes how to disable GTID transactions on servers that are already online. This procedure ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions.
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-start-replica.html
When you have enabled multiple channels on a replica, you can choose to either start all channels, or select a specific channel to start. Once you have added channels for all of the sources, issue a START SLAVE statement to start replication. For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%'; +----------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. If the database on the source contains existing data it is necessary to copy ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
You may either dump all databases or select databases to be dumped. 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 ...