SEO

#1 (**permalink**) 02-28-2008, 08:30 AM

Hi,

I am currently running three MySQL servers (all v5.0) set up in the
following format (round-robin):

ServerA --> ServerB --> ServerC |
^--------------------------------<

It doesnt really matter where, but I need to insert a fourth MySQL
server. I suspected I needed to use the 'LOAD DATA FROM MASTER'
command, but the documentation seems to suggest that thats been
superceded. How do I best go about this to ensure an accurate copy of
each database?

Thanks.

Ryan

#2 (**permalink**) 02-28-2008, 08:30 AM

Formatting doesnt really show it, but Server C's changes go to ServerA
Ryan Johnson wrote:
> Hi,
>
> I am currently running three MySQL servers (all v5.0) set up in the
> following format (round-robin):
>
> ServerA --> ServerB --> ServerC |
> ^--------------------------------<
>
>
> It doesnt really matter where, but I need to insert a fourth MySQL
> server. I suspected I needed to use the 'LOAD DATA FROM MASTER'
> command, but the documentation seems to suggest that thats been
> superceded. How do I best go about this to ensure an accurate copy of
> each database?
>
> Thanks.
>
> Ryan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Round-Robin replication - inserting server into loop