From: Manuel Arostegui
Date: October 26 2012 6:44am
Subject: Re: Replication Question
List-Archive: http://lists.mysql.com/mysql/228496
Message-Id: <CAA8xrZfPdNkSMTJu9N8G7wOp-T9dszD=-bp7FjzyqcWeStr2eQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0015174c373662b7c904ccf0a8d2

--0015174c373662b7c904ccf0a8d2
Content-Type: text/plain; charset=ISO-8859-1

2012/10/25 Sabika M <sabika.makhdoom@stripped>

> I have replication setup in the following way:
>
> A -> B ->C
>
> I am making updates to server A. I want to stop all my updates and point
> them to server C. After I start writing to server C, can I use the change
> master statement to make the C the master of A (take B out of the topology)
> and proceed to set up peer-to-peer between A <-> C without taking a new
> backup of c to set up the replication between A->C?
>
> I guess what I am really asking is if the data is the same, is a backup
> required for initialization?
>
> Hello,

Make sure you run a "show master status" at C before sending the writes to
it so you can get to know at which position/binlog you have to start A
replicating from. Also make sure read_only = OFF in C.

Manuel.

--0015174c373662b7c904ccf0a8d2--