PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
This happens so that a replica’s GTID set stays consistent with the source’s, meaning GTID auto-positioning can be used without re-acquiring filtered out transactions each time. This section explains how to work with replication filters when ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
To enable the plugins, set the appropriate system variable either at runtime using SET GLOBAL, or at server startup on the command line or in an option file. A setting listed in an option file takes effect each time the server starts.
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
If you use this approach, make sure you monitor the replication process to ensure that the time taken to run the backup does not affect the replica's ability to keep up with events from the source. Using mysqldump to create a copy of a database ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Restart the replicas, this time without the --skip-slave-start option or skip_slave_start system variable. When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
MySQL 8.0 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 19.4.11, “Delayed Replication”. Replication enables data from one MySQL database server ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. After the server accepts a connection, it enters ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache. Server-Side Runtime Configuration and Monitoring for SSL Session Reuse Client-Side Configuration for ...This section describes the conditions that are favorable for SSL session reuse, the server variables used for managing and monitoring the session cache, and the client command-line options for storing and reusing session ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, ...
https://dev.mysql.com/doc/refman/8.0/en/savepoint.html
In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL ...