Multi Master / Master Slave works using VPN sites On Tue, Feb 23, 2010 at 10:02 AM, jan gestre <[email protected]> wrote:
> 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 >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
