A two way communication between mysql databases on residing internet & intranet

[xux]

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.Thanks
XUX

[fenway]

"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.

[gluck]

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

[xux]

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

[fenway]

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.

[xux]

Yea,
      But there should be a finer control what is transfered.Can it be implemented with mysql?
Thanks a lot

[fenway]

Not that I'm aware of... master/slave & replication are just blind dumps.

[xux]

Hi,
  Talking about the replication,can it communicate between intranet and internet?Thanks

[fenway]

If the two boxes can see each other, yes.