Multi master replication apparently did the trick, still under observation though.
On Mon, Feb 22, 2010 at 10:59 AM, Zak B. Elep <[email protected]> wrote: > On Fri, Feb 19, 2010 at 11:17 PM, jan gestre <[email protected]> > wrote: > > Hi Guys, > > What would be the best way to achieve database replication wherein the > copy > > of db1 and db2 on MySQL server on network1 should be the same on MySQL > > server on network2, every time changes happen whether it happens on site1 > or > > site2, db1 and db2 on both sites should still be the same, raw data > > replication? or MySQL Master/Slave replication? using mysqldump run > through > > a script/cronjob? Both sites are connected via VPN tunnel. > > Thanks in advance. > > I used to do this ;) Looking at your ideas above, you're in the right > direction; you could do a simple mysqldump/restore option > semi-automated using scripts, or go for a MySQL cluster approach. > > -- > Zak B. Elep || zakame.net > 1486 7957 454D E529 E4F1 F75E 5787 B1FD FA53 851D > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > -- http://jangestre.blogpsot.com
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
