Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic function loading during server startup and manual loading thereafter. CREATE FUNCTION has these effects: It loads the function ...While a loadable function is loaded, information about it is available as described in Section 7.7.2, “Obtaining Information About Loadable ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-ssl-for-recovery.html
These options correspond to the server SSL options that are used for group communication connections, but they are only applied for distributed recovery connections. By default, distributed recovery connections do not use SSL, even if you activated ... Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied not just to distributed recovery connections, but to group communications between members in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-fault-tolerance.html
MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it requires a majority of servers to be active to reach quorum and thus make a decision. The number ...This has direct impact on the number of failures the system can tolerate without compromising itself and its overall ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server instance. Any replicated transactions that are received by group members on asynchronous replication channels from ...The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. When checksums are available, Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Some query conditions ...Evaluation of some views, such those that use the TEMPTABLE algorithm, UNION, or ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
The component_keyring_encrypted_file keyring component stores keyring data in an encrypted, password-protected file local to the server host. To use component_keyring_encrypted_file for keystore management, you must: Write a manifest that tells the ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Warning Normally, you should never have two servers that update data in the same databases. If (despite this warning) you run multiple servers using the same data directory and they have logging enabled, you must use the appropriate options to ...