PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...Use the CHANGE MASTER TO statement to configure a replication channel for each source on the replica (see Section 16.2.2, “Replication ...
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 ...Use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
The session user must have privileges sufficient to set restricted session variables. The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
server_uuid In MySQL 5.7, the server generates a true UUID in addition to the server_id value supplied by the user. The following sections contain information about mysqld options and server variables that are used in replication and for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), MASTER_POS_WAIT(), PASSWORD(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and UUID_SHORT().
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
When one user is too busy, this slows it down, which can be useful in some deployment situations. In addition to the built-in asynchronous replication, MySQL 5.7 supports an interface to semisynchronous replication that is implemented by plugins.
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-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). You can tell a replica to change to a new source using the CHANGE MASTER TO statement. The replica does not check ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
During data directory initialization, MySQL creates user accounts that should be considered reserved: 'root'@'localhost: Used for administrative purposes. One part of the MySQL installation process is data directory initialization (see Section ...