My Oracle Support Banner

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

Last updated on MAY 03, 2021

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.


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:

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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