My Oracle Support Banner

Use mysqldump To Create A New GTID Based Multi-Source Replication Channel From A Live Replication Source (Doc ID 2169628.1)

Last updated on APRIL 21, 2021

Applies to:

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

Goal

This document provides a method to add a new GTID based multi-source replication channel from a live replication source using mysqldump without significantly affecting the new source and other existing channels on the replica.  It explains the step-by-step process required to add a new GTID based replication channel while the new source is live and still receiving transactions, the new source need not to be made read only.

This document can be regarded as the supplement for the Doc ID 2159833.1 .

Solution

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
Goal
Solution
References


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