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/replication-semisync.html
Semisynchronous replication between a source and its replicas operates as follows: A replica indicates whether it is semisynchronous-capable when it connects to the source. In addition to the built-in asynchronous replication, MySQL 8.0 supports an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
The following combination of settings on a replica is the most resilient to unexpected halts: When GTID-based replication is in use (gtid_mode=ON), set SOURCE_AUTO_POSITION=1 | MASTER_AUTO_POSITION=1, which activates GTID auto-positioning for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a source. Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, mysqldump, and mysqlpump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted to connect from the given host. MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Have your application connect to the database using a user name different from the one you use for administrative purposes. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html
MySQL Enterprise Edition includes audit logging for monitoring and logging of connection and query activity. MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...