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

(Doc ID 2159833.1)

Last updated on DECEMBER 29, 2016

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

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 hundreds of Community platforms