Sound right. Be sure there are no writes during certain critical times. And that replication is caught up.
If you want to verify the "sameness" see Percona's pt-table-checksum. > -----Original Message----- > From: Sabika M [mailto:sabika.makhd...@gmail.com] > 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- > >C? > > I guess what I am really asking is if the data is the same, is a backup > required for initialization? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql