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 JUNE 01, 2018

Applies to:

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

Goal

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

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!


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