Search Results
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
Query Employed for user clients while executing queries by single-threaded replication applier threads, as well as by the replication coordinator thread. A thread can have any of the following Command values: Binlog Dump This is a thread on a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
The replication master key is then put into a keyring data file, which is encrypted with the user password supplied with the option --encrypt-password, and then saved under the meta folder in the backup with the name keyring_kef. mysqlbackup creates ... MySQL Enterprise Backup supports encrypted binary and relay logs, which are handled in a similar way as the encrypted InnoDB tables are (see Chapter 6, Working with Encrypted InnoDB Tablespaces for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/connection-options.html
When mysqlbackup creates a backup, it sends SQL commands to a MySQL server using a database server connection. The way to create a connection is similar to what is described in Connecting to the MySQL Server Using Command Options of the MySQL 8.4 ...If you do not provide a value for the --password, the command prompts for one from the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-rest-api-setup.html
This guide sets up a basic Router REST API, adds basic authentication, and exposes a route to check Router's status. The REST API is configured using configuration sections and options are required to enable and use the REST API. For example, ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-installation-source-cpp.html
Only out-of-source-builds are supported, so create a directory to use for the build and change location into it. (However, it may be that your version of CMake supports more generators than can actually be used to build Connector/C++.) If the Boost ... To install Connector/C++ from source, verify that your system satisfies the requirements outlined in Section 2.4.1, “Source Installation System ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Object Changed: Database Has Been Created For development environments, changes to databases and objects may be a normal occurrence, but not for production environments. Default frequency ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. However, it is not difficult in MySQL to create partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key ...