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:

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

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