Rechercher dans le manuel MySQL

5.6.7.6 Cloning for Replication

Inhaltsverzeichnis

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


Suchen Sie im MySQL-Handbuch

Deutsche Übersetzung

Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.

Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.

Vielen Dank im Voraus.

Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-clone-plugin-replication.html

Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.

Referenzen

  1. Zeigen Sie - html-Dokument Sprache des Dokuments:en Manuel MySQL : https://dev.mysql.com/

Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.

Inhaltsverzeichnis Haut