PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replica-logs.html
Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
The replica uses a monitor thread to track the membership of managed groups and update the source list (thread/sql/replica_monitor). To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
However, statements that would normally update this information indirectly—such GRANT, REVOKE, and statements manipulating triggers, stored routines, and views—are replicated to replicas using statement-based replication. Data modification ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-optimizer.html
(In general, this is not a good practice, even outside of replication.) Examples of nondeterministic statements include DELETE or UPDATE statements that use LIMIT with no ORDER BY clause; see Section 19.5.1.18, “Replication and LIMIT”, for a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
The replica also receives and applies transactions from source1 if source2 is configured with log_replica_updates=ON, but it does not do so if source2 uses log_replica_updates=OFF. This section provides examples of stored functions (see Chapter 27, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
They represent the replication coordinates at which the replica should begin processing new updates from the source. To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. Under Unix: $> mysqld_safe & Under Windows: C:\> "C:\Program ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. For information about steps to ...