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
