PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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 9.7 supports an ...
https://dev.mysql.com/doc/refman/9.7/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, which activates GTID auto-positioning for the connection to the source to ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. The following log-specific sections provide information about the server options that enable logging. By default, the server writes files for all enabled logs ...