Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. It registers the function in the mysql.func system table to make it persistent across server restarts. For this reason, CREATE FUNCTION requires the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-communication-protocol.html
Return value: The oldest MySQL Server version that can join this group and use the group's communication protocol. Note that the group_replication_get_communication_protocol() function returns the minimum MySQL version that the group supports, which ... The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
Group Replication does not handle client-side failover itself, so you need to arrange this using a middleware framework such as MySQL Router 8.4, a proxy, a connector, or the application itself. MySQL 8.4 supports atomic Data Definition Language ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-plugin-architecture.html
MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction identifiers. It integrates with current MySQL ...There are interfaces to make information flow from the server to the plugin and vice ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
If SSL is used, the means for configuring the secure connection depends on whether the XCom or the MySQL communication stack is used for group communication. Important Support for the TLSv1 and TLSv1.1 connection protocols was removed in MySQL 8.0.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade-with-mysqlbackup.html
As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members. However you cannot use this technique to directly restore a backup taken from a member running an older version ...Repeat this process to create a suitable number of new instances, for example to be able to handle a ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', -> '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57')\G *************************** ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. The identifier quote character is the backtick (`): mysql> ...Section 11.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
https://dev.mysql.com/doc/refman/8.4/en/making-windows-dumps.html
Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite distribution of MySQL. These files provide information for debugging your MySQL installation in the event of a problem. The PDB file contains more ...This is a separate download from the standard MSI or Zip ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. If you store values larger than the display width in an integer column that has the ZEROFILL ...