Search Results
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/ibd2sdi.html
ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* files), and the data dictionary tablespace (mysql.ibd). For example: Usage: ./ibd2sdi [-v] [-c ... ibd2sdi ...
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/innodb-change-buffer.html
For answers to frequently asked questions about the change buffer, see Section A.16, “MySQL 8.4 FAQ: InnoDB Change Buffer”. You can set the innodb_change_buffering variable in the MySQL option file (my.cnf or my.ini) or change it dynamically ...
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/monitor-innodb-mutex-waits-performance-schema.html
To ensure that all InnoDB mutex instances are instrumented and enabled, add the following performance-schema-instrument rule to your MySQL configuration file: performance-schema-instrument='wait/synch/mutex/innodb/%=ON' If you do not require wait ...