Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
For instructions to set up SSL for distributed recovery connections and create a replication user that requires SSL, see Section 20.6.3, “Securing Distributed Recovery Connections” Important By default, users created in MySQL 8 use Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
Most MySQL programs that support option files handle the following options. Exceptions: Even with --defaults-file, mysqld reads mysqld-auto.cnf and client programs read .mylogin.cnf. For example, the mysql client normally reads the [client] and ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. In the syntax just shown, column_list is a list of one or more columns (sometimes called a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. The database updates are automatically propagated to the replicas: $> mysql -h source < fulldb.dump 19.1.2.6.2 Setting Up Replication with ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all platforms. On Unix-like systems, including Linux, you can check your system's ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. This enables the ; delimiter used in the procedure ... Each stored program contains a body that consists of an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables used with MySQL Server. For example, X Plugin can have SSL key, certificate, and ... This section explains how to configure X Plugin to use encrypted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.verify.html
The following is a sample command for validating a backup image and the output for the successful validation: $ mysqlbackup --backup-image=/home/meb/mysql/backups/testback3.mbi validate MySQL Enterprise Backup Ver 8.4.0-commercial for Linux on ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes data from all MySQL storage engines, any third-party storage engines, and even any non-database files in that ...This section explains options you can use to selectively back up or exclude ...