Rechercher dans le manuel MySQL
5.6.7.12 Clone System Variables
This section describes the system variables that control operation of the clone plugin. If values specified at startup are incorrect, the clone plugin may fail to initialize properly and the server does not load it. In this case, the server may also produce error messages for other clone settings because it will not recognize them.
Each system variable has a default value. System variables can
be set at server startup using options on the command line or in
an option file. 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.
Setting a global system variable runtime value normally requires
the SYSTEM_VARIABLES_ADMIN
or
SUPER
privilege. For more
information, see Section 5.1.9.1, “System Variable Privileges”.
Clone variables are configured on the recipient MySQL server instance where the cloning operation is executed.
-
Property Value Command-Line Format --clone-autotune-concurrency
Introduced 8.0.17 System Variable clone_autotune_concurrency
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Boolean Default Value ON
Enables dynamic spawning of threads for remote cloning operations. The
clone_max_concurrency
variable defines the maximum number of threads that can be spawned. Whenclone_autotune_concurrency
is disabled, the maximum number of threads is spawned for remote cloning operations. -
Property Value Command-Line Format --clone-buffer-size
Introduced 8.0.17 System Variable clone_buffer_size
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 4194304
Minimum Value 1048576
Maximum Value 268435456
Defines the size of the intermediate buffer used when transferring data during a cloning operation. The default value is 4 mebibytes (MiB). A larger buffer size may permit I/O device drivers to fetch data in parallel, which can improve cloning performance.
-
Property Value Command-Line Format --clone-ddl-timeout
Introduced 8.0.17 System Variable clone_ddl_timeout
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 300
Minimum Value 0
Maximum Value 2592000
The time in seconds to wait for a backup lock when executing a cloning operation. A cloning operation cannot run concurrently with DDL operations. A backup lock is required on the donor and recipient MySQL server instances. The cloning operation waits for current DDL operations to finish. Once backup locks are acquired, DDL operations must wait for the cloning operation to finish. A value of 0 means that no backup lock is to be taken for the cloning operation. In this case, the cloning operation fails with an error if a DDL operation is attempted concurrently.
-
Property Value Command-Line Format --clone-enable-compression
Introduced 8.0.17 System Variable clone_enable_compression
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Boolean Default Value OFF
Enables compression of data at the network layer during a remote cloning operation. Compression saves network bandwidth at the cost of CPU. Enabling compression may improve the data transfer rate.
-
Property Value Command-Line Format --clone-max-concurrency
Introduced 8.0.17 System Variable clone_max_concurrency
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 16
Minimum Value 1
Maximum Value 128
Defines the maximum number of concurrent threads used to perform a remote cloning operation. The default value is 16. Increasing the number of threads can improve cloning performance but doing so reduces the number of permitted simultaneous client connections, which can affect the performance of existing client connections.
A minimum data transfer rate of 1 mebibyte (MiB) per thread is recommended for remote cloning operations. The data transfer rate for a remote cloning operation is controlled by the
clone_max_data_bandwidth
variable. -
Property Value Command-Line Format --clone-max-data-bandwidth
Introduced 8.0.17 System Variable clone_max_data_bandwidth
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 0
Minimum Value 0
Maximum Value 1048576
Defines the maximum data transfer rate in mebibytes (MiB) per second for a remote cloning operation. This variable helps manage the performance impact of a cloning operation. A limit should be set only when donor disk I/O bandwidth is saturated, affecting performance. A value of 0 means “unlimited”, which permits cloning operations to run at the highest possible data transfer rate.
The minimum data transfer rate is 1 MiB per second, per thread. For example, if there are 8 threads, the minimum transfer rate is 8 MiB per second. The
clone_max_concurrency
variable controls the maximum number threads spawned for a remote cloning operation.The requested data transfer rate specified by
clone_max_data_bandwidth
may differ from the actual data transfer rate reported by theDATA_SPEED
column in theperformance_schema.clone_progress
table. -
Property Value Command-Line Format --clone-max-network-bandwidth
Introduced 8.0.17 System Variable clone_max_network_bandwidth
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 0
Minimum Value 0
Maximum Value 1048576
Specifies the maximum approximate network transfer rate in mebibytes (MiB) per second for a remote cloning operation. This variable can be used to manage the performance impact of a cloning operation on network bandwidth. It should be set only when network bandwidth is saturated, affecting performance on the donor instance. A value of 0 means “unlimited”, which permits cloning at the highest possible data transfer rate over the network, providing the best performance.
-
Property Value Command-Line Format --clone-ssl-ca=file_name
Introduced 8.0.14 System Variable clone_ssl_ca
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type File name Default Value empty string
Specifies the path to the certificate authority (CA) file. Used to configure a secure connection for a remote cloning operation.
-
Property Value Command-Line Format --clone-ssl-cert=file_name
Introduced 8.0.14 System Variable clone_ssl_cert
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type File name Default Value empty string
Specifies the path to the public key certificate. Used to configure a secure connection for a remote cloning operation.
-
Property Value Command-Line Format --clone-ssl-key=file_name
Introduced 8.0.14 System Variable clone_ssl_key
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type File name Default Value empty string
Specifies the path to the private key file. Used to configure a secure connection for a remote cloning operation.
-
Property Value Command-Line Format --clone-valid-donor-list=value
Introduced 8.0.17 System Variable clone_valid_donor_list
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type String Default Value empty string
Defines valid donor host addresses for remote cloning operations. A comma-separated list of values is permitted in the following format: “
HOST1:PORT1,HOST2:PORT2,HOST3:PORT3
”. Spaces are not permitted.Internet Protocol version 6 (IPv6) address format is not supported. Internet Protocol version 6 (IPv6) address format is not supported. An alias to the IPv6 address can be used instead. An IPv4 address can be used as is.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-clone-plugin-options-variables.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.