List:General Discussion« Previous MessageNext Message »
From:Rick James Date:October 25 2012 8:11pm
Subject:RE: Replication Question
View as plain text  
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.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-
> >C?
> 
> I guess what I am really asking is if the data is the same, is a backup
> required for initialization?
Thread
Replication QuestionSabika M25 Oct
  • RE: Replication QuestionRick James25 Oct
  • Re: Replication QuestionManuel Arostegui26 Oct