Clone a Replication Replica Server From a Live Source Server using Global Transaction IDs (GTID) and mysqldump (Doc ID 1589291.1)

Last updated on APRIL 09, 2023

Applies to:

Goal

To clone a replication replica server from a live source server with existing data, extra steps must be taken to ensure that the data is copied as a consistent snapshot, and that the correct GTID status is transferred to the replica server.

The requirements to achieve this are described in the manual here, but it does not fully detail the steps from start to finish:

• Setting Up Replication Using GTIDs
• Using GTIDs for Failover and Scaleout

This document explains the step-by-step process required to clone a source server while it is live and still receiving transactions, the servers need not be made read only. This process assumes a completely blank MySQL replica server system.

If any of the steps do not behave as expected, please see the Error Log file which may contain useful information. To locate the error log, see <Note 1478045.1>.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.