xux Posted November 2, 2006 Share Posted November 2, 2006 Hi, I want to know whether mysql can be configured in such a way that two different databases one residing on the internet and the other on the intranet can communicate with each other(once one is updated the other get all the recent data).Am sure there must be an access point but is it possible.ThanksXUX Quote Link to comment Share on other sites More sharing options...
fenway Posted November 2, 2006 Share Posted November 2, 2006 "Access point"? You can connect to as many databases as you want, and as long as you hold the records in memory, you can move them too. Quote Link to comment Share on other sites More sharing options...
gluck Posted November 2, 2006 Share Posted November 2, 2006 Are you hinting on replication? You can create backups of the database or replicate them. Also you can perform clustering. Now going back to your question - databases can communicate with many different protocols irrespective of the location Quote Link to comment Share on other sites More sharing options...
xux Posted November 3, 2006 Author Share Posted November 3, 2006 Thanks, Let me shed more light.I am from a developing country where the internet is not always available.Am working with an organisation that is skeptical of moving there data online cos it is not always dependable.But we are working on the idea of the databases online(internet) and the one residing on the intranet communication(i.e once one is uploaded the other get uploaded automatically).I was asked to look into the possibilities and whether mysql can implement it.Please I hope I can get answers and how to implement it.Thanks a lot Quote Link to comment Share on other sites More sharing options...
fenway Posted November 3, 2006 Share Posted November 3, 2006 Well, this does sound like a master/slave setup... so replication may be more appropriate, unless you want finer control over what gets transferred when. Quote Link to comment Share on other sites More sharing options...
xux Posted November 3, 2006 Author Share Posted November 3, 2006 Yea, But there should be a finer control what is transfered.Can it be implemented with mysql?Thanks a lot Quote Link to comment Share on other sites More sharing options...
fenway Posted November 4, 2006 Share Posted November 4, 2006 Not that I'm aware of... master/slave & replication are just blind dumps. Quote Link to comment Share on other sites More sharing options...
xux Posted November 5, 2006 Author Share Posted November 5, 2006 Hi, Talking about the replication,can it communicate between intranet and internet?Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted November 6, 2006 Share Posted November 6, 2006 If the two boxes can see each other, yes. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.