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