Rechercher dans le manuel MySQL

5.6.7.12 Clone System Variables

Inhoudsopgave

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.

  • clone_autotune_concurrency

    Property Value
    Command-Line Format --clone-autotune-concurrency
    Introduced 8.0.17
    System Variable clone_autotune_concurrency
    Scope Global
    Dynamic Yes
    SET_VAR Hint Applies No
    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. When clone_autotune_concurrency is disabled, the maximum number of threads is spawned for remote cloning operations.

  • clone_buffer_size

    Property Value
    Command-Line Format --clone-buffer-size
    Introduced 8.0.17
    System Variable clone_buffer_size
    Scope Global
    Dynamic Yes
    SET_VAR Hint Applies No
    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.

  • clone_ddl_timeout

    Property Value
    Command-Line Format --clone-ddl-timeout
    Introduced 8.0.17
    System Variable clone_ddl_timeout
    Scope Global
    Dynamic Yes
    SET_VAR Hint Applies No
    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.

  • clone_enable_compression

    Property Value
    Command-Line Format --clone-enable-compression
    Introduced 8.0.17
    System Variable clone_enable_compression
    Scope Global
    Dynamic Yes
    SET_VAR Hint Applies No
    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.

  • clone_max_concurrency

    Property Value
    Command-Line Format --clone-max-concurrency
    Introduced 8.0.17
    System Variable clone_max_concurrency
    Scope Global
    Dynamic Yes
    SET_VAR Hint Applies No
    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.

  • clone_max_data_bandwidth

    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 Applies No
    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 the DATA_SPEED column in the performance_schema.clone_progress table.

  • clone_max_network_bandwidth

    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 Applies No
    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.

  • clone_ssl_ca

    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 Applies No
    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.

  • clone_ssl_cert

    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 Applies No
    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.

  • clone_ssl_key

    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 Applies No
    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.

  • clone_valid_donor_list

    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 Applies No
    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.


Zoek in de MySQL-handleiding

Nederlandse vertaling

U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.

Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.

Bij voorbaat dank.

Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-clone-plugin-options-variables.html

De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.

Referenties

  1. Bekijk - html-document Taal van het document:en Manuel MySQL : https://dev.mysql.com/

Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.

Inhoudsopgave Haut