List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:September 18 2003 4:53am
Subject:Re: Round Robin Replication, Add a server; Renumber
View as plain text  
On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote:
> I currently have three mysql machines replication from A-B-C-A type
> fashion. I need to replace A. I am thinking that I could add D and have it
> pull from C. Then once A is removed restart D as A. Is this a good way to
> do this or is there a better way that I should do this?

Can't you make D a slave of A?  Then swap it for A when you're ready?

Or, pull A's disks and put 'em in D?
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 159,055,861 queries (438/sec. avg)
Thread
Round Robin Replication, Add a server; RenumberLewis Watson3 Sep
  • Re: Round Robin Replication, Add a server; RenumberJeremy Zawodny18 Sep
    • Re: Round Robin Replication, Add a server; RenumberFranky18 Sep
      • Re: Round Robin Replication, Add a server; RenumberJeremy Zawodny19 Sep