On Thu, Sep 18, 2003 at 10:07:22AM +0200, Franky wrote: > Jeremy Zawodny wrote: > > > 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? > > Are you saying that D will detect the correct master_file pos when you > change it's master from A to B then (since D was then a slvae of A and > you replace A by D)?
No. But when you CHANGE MASTER on D, you'd simply use the values from A if you keep A and D in sync. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 5 days, processed 190,072,594 queries (439/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
