Be sure there are no writes during certain critical times. And that replication is caught
If you want to verify the "sameness" see Percona's pt-table-checksum.
> -----Original Message-----
> From: Sabika M [mailto:sabika.makhdoom@stripped]
> Sent: Thursday, October 25, 2012 10:16 AM
> To: MySql
> Subject: Replication Question
> 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-
> I guess what I am really asking is if the data is the same, is a backup
> required for initialization?