Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
You set and manage source lists using the asynchronous_connection_failover_add_source and asynchronous_connection_failover_delete_source functions to add and remove single replication source servers. To add and remove managed groups of servers, use ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...You must obtain (or create) a suitable security certificate that you can use on the source, and a similar certificate (from the same certificate authority) on each ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-configuration.html
Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/mysql-threads.html
The MySQL server creates the following threads: Connection manager threads handle client connection requests on the network interfaces that the server listens to. The server does not create threads to handle interfaces that it does not listen to.
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-characteristics.html
The server plugin API has these characteristics: All plugins have several things in common. If the API changes over time, the version numbers will change, but a server can examine a given plugin library's version information to determine whether it ...Each plugin has a name that it can be referred to in SQL statements, as well as other metadata such as an author and a description that provide other ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api.html
MySQL supports a plugin API that enables creation of server components. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The components supported by this interface include, but are not ...The ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-password-validation-plugins.html
This section describes how to write a server-side password-validation plugin. plugin.h defines the MYSQL_VALIDATE_PASSWORD_PLUGIN server plugin type and the data structures needed to declare the plugin. A password-validation plugin, like any MySQL ...The instructions are based on the source code in the plugin/password_validation directory of MySQL source ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-22.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. (WL #13780) When trying to open multiple connections to a MySQL server using Connector/J with a named pipe on Windows systems, the attempt sometimes failed with the "All pipe ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
It is suitable for use with MySQL Server versions 5.5, 5.6, 5.7, and 8.0. (WL #10156) X DevAPI: The connection property enabledTLSProtocols can now be used to select the allowed TLS versions for an X Protocol connection to the server. Note To ...