Edson Luiz Q. Zen Junior wrote:
> Hi I'm researching a way to make several servers
> sparsed apart (about 9 of them) linked using
> Internet to keep data in sync between them....
>
> Like there will be 8 warehouses located thruout my
> state were they all must be online and hourly
> writing their data to a main server... But the
> main server must also write data to the other 8
> server...
>
> Explaining better: I couldn't make all the 8
> warehouses use the main server cause internet is
> not very stable in some areas... Thus If the net
> is down no one works? Then I thought making 8
> server (one for each) would do the trick... Then
> If someone pays a bill in one of the warehouses it
> must go to the central server... And if someone
> pays something on the main server location it must
> go to the all the other servers...
>
> Is there a way of using replication to help me
> with this? Or any other automated procedure to
> make this or should it be done manually designing
> the tables or something??
>
> I'm kinda of lost cause never done this before and
> don't even know the name of this....
>
> Thanks for any help...
What you are really looking for is n-way replication, which we don't have at the moment. It is slated for a future version of MySQL though.
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com