Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
You can appoint a specific member as the new primary using the group_replication_set_as_primary() function. If you use the group_replication_switch_to_single_primary_mode() function to change a group that was running in multi-primary mode to run in ... In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write ...
https://dev.mysql.com/doc/refman/8.4/en/if.html
Note There is also an IF() function, which differs from the IF statement described here. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-types.html
The permitted key lengths are subject to multiple factors: General keyring loadable-function interface limits (for keys managed using one of the keyring functions described in Section 8.4.4.12, “General-Purpose Keyring Key-Management ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be ... The ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. You can avoid using LOCK TABLES in many cases by using relative updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function. You ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation process. It offers two options: Note This upgrade functionality was added in MySQL 8.3.0. Note The existing MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
For example, thread/sql/one_connection corresponds to the thread function in the code responsible for handling a user connection, and thread/sql/main stands for the main() function of the server. This is the same value displayed in the ID column of ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
You can set up the replication channel using CHANGE REPLICATION SOURCE TO, or if the new servers are provisioned using MySQL's clone functionality, this all happens automatically. Because the sources do not have to be in a managed group, you can set ... Asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO statement for the ...