Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-concurrent-ddl.html
Concurrent DDL support can be enabled and disabled dynamically using a SET statement like this one: SET GLOBAL clone_block_ddl={OFF|ON} The default setting is clone_block_ddl=OFF, which permits concurrent DDL on the donor. In MySQL 8.4, concurrent ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
An error is reported if an encrypted connection is not available or the REQUIRE NO SSL clause is used in the CLONE INSTANCE statement. The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
The X Protocol port specified by mysqlx_port is not supported for remote cloning operations (when specifying the port number of the donor MySQL server instance in a CLONE INSTANCE statement). The clone plugin is subject to these limitations: An ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning operation. The user you select to perform the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
They can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart it. This section describes the system variables that control operation of the clone plugin.
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
The CHANGE REPLICATION SOURCE TO statement must define the host address and port number of the source, and the SOURCE_AUTO_POSITION option should be enabled, as shown: CHANGE SOURCE TO SOURCE_HOST = 'source_host_name', SOURCE_PORT = source_port_num, ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-stop.html
If necessary, you can stop a cloning operation with a KILL QUERY processlist_id statement. On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status ...
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/8.4/en/connecting-disconnecting.html
mysql> The mysql> prompt tells you that mysql is ready for you to enter SQL statements. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it ...