My Oracle Support Banner

Adding A New GTID Based Multi-Source Replication Channel Using mysqldump (New Master Read Only Temporarily) (Doc ID 2159833.1)

Last updated on MARCH 01, 2020

Applies to:

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


Add a new GTID based multi-source replication channel using mysqldump.
This document explains the step-by-step process to add a new GTID based replication channel on the slave for a new master server. The new master need be made read only to make sure the slave can synchronize with it.  For the process that the new master need NOT be made read only to ensure it living and still receiving transactions, please see Doc ID 2169628.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.