MySQL Forums
Forum List  »  Replication

Re: master and slave in two different network
Posted by: Duncan Berriman
Date: September 16, 2005 12:02PM

All works fine for me.

I have servers replicating in the same data centre on the same network and a disaster recovery server in a seperate data centre at the other end of the country.

Shouldn't use any more bandwidth theoretically regardless of where they are, only difference will be the time lag as the network response will be much slower. To work this out do a ping of the local network between the two servers and between the US and UK server. If it takes 100 times longer then the replication will be similarly slower. As long as it can keep up it should not be a problem.

I guess there may be some underlying extra bandwidth used but I don't know enough about tcp/ip to advise on that.

I'd suggest you write a cron job to check replication is working and warn you when its not.

Options: ReplyQuote

Written By
Re: master and slave in two different network
September 16, 2005 12:02PM

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.