Rechercher dans le manuel MySQL

5.6.7.6 Cloning for Replication

Inhoudsopgave

The clone plugin supports replication. In addition to cloning data, a cloning operation extracts and transfers replication coordinates from the donor and applies them on the recipient, which enables using the clone plugin for provisioning Group Replication members and replication slaves. Using the clone plugin for provisioning is considerably faster and more efficient than replicating a large number of transactions.

Note

Group Replication members can also be configured to use the clone plugin as an alternative method of recovery, so that members automatically choose the most efficient way to retrieve group data from seed members. For more information, see Section 18.4.3.1, “Cloning for Distributed Recovery”.

Both binary log position (filename, offset) and GTID coordinates are extracted and transferred from the donor MySQL server instance.

  • Issue this query on a cloned MySQL server instance to view the binary log position that was applied:

    1. mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;

  • Issue this query on a cloned MySQL server instance to view the GTID of last transaction cloned to the recipient:

    1. mysql> SELECT @@GLOBAL.GTID_EXECUTED;

    If a recipient running with GTID_MODE=ON clones from a donor with GTID_MODE=OFF, both the GTID and binary log position replication coordinates are applied on the recipient.

The replication coordinates that are applied on the recipient permit initiating replication from the donor at a consistent position in the replication stream, assuming that the binary logs required for the recipient to catch up to the donor are not purged between the time that the data is cloned and the time that replication is started. If the required binary logs are not available, a replication handshake error is reported.

A cloned instance should be added to a group or cluster without excessive delay to avoid required binary logs being purged or the new member lagging behind significantly, requiring more recovery time.

The cloning operation does not configure or modify replication-related configuration settings on the recipient MySQL server instance.

To clone for replication, perform the following steps:

  1. Clone data from the donor MySQL server instance to the recipient.

    • If you are adding a member to a Group Replication cluster, the donor must be a member in the cluster.

    • If you are adding a slave to a MySQL replication group, the donor must be a master or slave in the replication group.

    For cloning instructions, see Section 5.6.7.3, “Cloning Remote Data”.

  2. After the cloning operation completes successfully, add the recipient MySQL server instance to the Group Replication cluster or MySQL replication group.

    The instructions that follow provide abbreviated examples for adding a recipient MySQL server instance to a Group Replication cluster, a replication group that uses GTID-based transactions as the replication data source, and a replication group that uses binary log file position based replication. Refer to the instructions that apply to your replication setup.

    • Adding to a Group Replication cluster.  To add the recipient MySQL server instance to a Group Replication cluster, configure the instance for Group Replication, and add the instance to the group, as shown in this abbreviated example:

      1. mysql> CHANGE MASTER TO MASTER_USER = 'user_name', MASTER_PASSWORD = 'password',
      2.        ...
      3.        FOR CHANNEL 'group_replication_recovery';
      4. mysql> START GROUP_REPLICATION;

      For detailed information about adding an instance to a Group Replication cluster, refer to Section 18.2.1.6, “Adding Instances to the Group”.

    • Adding to a replication group that uses GTID-based transactions.  To add a recipient MySQL server instance to a MySQL replication group that uses GTID-based transactions as the replication data source, configure the instance as required, and add the instance as shown in the following abbreviated example.

      The CHANGE MASTER TO statement must define the host address and port number of the donor instance, and the MASTER_AUTO_POSITION option should be enabled, as shown:

      1. mysql> CHANGE MASTER TO MASTER_HOST = 'donor_host_name', MASTER_PORT = donor_port_num,
      2.        ...
      3.        MASTER_AUTO_POSITION = 1;
      4. mysql> START SLAVE USER = 'user_name' PASSWORD = 'password';

      For detailed information about adding an instance to a MySQL replication group that uses GTID-based transactions as the replication data source, refer to Section 17.1.3, “Replication with Global Transaction Identifiers”.

    • Adding to a MySQL replication group that uses binary log file position.  To add a recipient MySQL server instance to a MySQL replication group that uses binary log file position based replication, configure the instance as required, and add the instance as shown in the following abbreviated example.

      Adding the recipient MySQL server instance to the group requires knowing the binary log position applied to the recipient instance.

      1. mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;  
      2. mysql> CHANGE MASTER TO MASTER_HOST = 'donor_host_name', MASTER_PORT = donor_port_num,
      3.        ...
      4.        MASTER_LOG_FILE = 'master_log_name',
      5.        MASTER_LOG_POS = master_log_pos;
      6. mysql> START SLAVE USER = 'user_name' PASSWORD = 'password';

      For detailed information about adding an instance to a MySQL replication group that uses binary log file position based replication, refer to Section 17.1.2, “Setting Up Binary Log File Position Based Replication”.


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-replication.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