MySQL Forums
Forum List  »  Replication

Re: Will Replication Help me with this?
Posted by: Partha Dutta
Date: September 25, 2005 11:35AM

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.

Options: ReplyQuote

Written By
Re: Will Replication Help me with this?
September 25, 2005 11:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.