Use mysqldump To Create A New GTID Based Multi-Source Replication Channel From A Live Master

(Doc ID 2169628.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

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

This document can be regarded as the supplement for the Doc ID 2159833.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