Two way replication is possible. However, it does not work like you think it would. It would not be safe to modify data on both databases at the same time. See the FAQ on replication: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
There is some information regarding two-way replication that will shed some light on the subject. Jim Grill > yeah, I seen that have. Have you tried that before? I need to do it > two-way. But have not seen any special setup for that. Each site > will be entering data and all sites will need to see the updated > change. > > > On Fri, 01 Oct 2004 10:38:07 -0400, Michael Stassen > <[EMAIL PROTECTED]> wrote: > > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
