PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 | MASTER_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10 | MASTER_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. For a managed group, a source’s weight is ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 on the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
Consider revising the binary log expiration period (binlog_expire_logs_seconds) on the source to ensure that the situation does not occur again. The second channel to attempt it skips the transaction using GTID auto-skip, because the transaction’s ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. This procedure does not require taking the server offline and is suited to use in ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
If you are restoring a backup that is disjoint from the transactions that are already on the server, for example provisioning a multi-source replica using dumps from two different servers, use the second method of adding to the value of gtid_purged.
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
The second channel to attempt it skips the transaction using GTID auto-skip, because the transaction’s GTID was added to the gtid_executed set by the first channel. This section explains how to work with replication filters when multiple ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
rpl_semi_sync_source_timeout or rpl_semi_sync_master_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. When you install ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. This enables assignment of sets of privileges to accounts and ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
As of MySQL 8.0.34, the scheduler component provides an implementation of the mysql_scheduler service that enables applications, components, or plugins to configure, run, and unconfigure tasks every N seconds. Note The scheduler component is ...