Have you considered replication
<http://dev.mysql.com/doc/mysql/en/Replication.html>?
Michael
spiv007 wrote:
I want to know what to best way to keep a 4 mysql servers sync.
I have 4 remote locations, I am thinking about putting a mysql server
in each location and every hour have the 1 db that I need to sync to
sync together.
Is there away to do its in somewhat real time or even a delay maybe of
an hour or two?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
