Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-client-authentication.html
The server may want to authenticate a client and require the client to provide an SSL certificate to it, which it verifies against its known certificate authorities or performs additional checks on the client identity if needed (see CREATE USER ...
https://dev.mysql.com/doc/internals/en/a-mysql-client-logs-in.html
which responds with a handshake packet which contains the version, some flags and a password challenge.: client -> server 3a 00 00 01 05 a6 03 00 00 00 00 01 08 00 00 00 :............... The client answers with username, some flags and the response ...00 00 27 75 3e 6f 38 66 79 4e 00 ff f7 08 02 00 ...
https://dev.mysql.com/doc/refman/9.7/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. (Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style ...In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. After restarting a busy server, there is ...The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-two-channels.html
This requires a total of four replication servers, two source servers on the source cluster and two replica servers on the replica cluster. First, the mysqld processes for the primary and secondary replication source servers must be started, ... In ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-configuration-tls.html
The default behavior is: client_ssl_mode = PREFERRED server_ssl_mode = AS_CLIENT This establishes TLS connections between the client and Router if the client desires switching to TLS and the server supports TLS. This also matches the existing ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-rest-api-reference.html
This is the maximum number (integer) of idling server connections in the connection pool. GET /connection_pool/{name}/status Shows reusedConnections as a count (integer) of client connections that reused a server connection since the application ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-failover.html
In this situation, the partitioned areas of the InnoDB ClusterSet topology begin to diverge from each other, with a different transaction set on each group of servers. To carry out an emergency failover for the primary InnoDB Cluster, follow this ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/refman/9.7/en/keyring-file-component.html
The component_keyring_file keyring component stores keyring data in a file local to the server host. Security standards such as PCI, FIPS, and others require use of key management systems to secure, manage, and protect encryption keys in key vaults ...Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory compliance ...