Hi Jan, Have you considered a second WAN / ISP and a load-balancing router? Router can be another Linux box. The second WAN can be POTS at the vey least or any of the excellent fallbacks that COMELEC proffers to use. 8-p
Cheers, Glenn On Sat, Feb 20, 2010 at 3:13 PM, jan gestre <[email protected]> wrote: > Hi Mark, > Actually site1's application server is originally connecting to site2's db > server however due to circumstances I have no control of (vpn tunnel breaks > down all the time, the ISP sucks!), in lieu of this I have to device another > way in order to achieve the desired goal. > Site1 and Site2's DB servers are independent of each however 2 db's which > resides on those servers need to be in sync. There will be no instance of > updating same sets of data, they will be updating different sets of records > however any changes made need to reflect on site1's DB server and vice > versa. > Regards, > Jan > > On Sat, Feb 20, 2010 at 10:08 AM, Mark David Dumlao <[email protected]> > wrote: >> >> Multiple entry points for data? That seems to imply a cluster rather >> than database replication. >> >> mysqldump, raw data replication, replication are all premised on there >> being an authoritative server. You can't just use those if the nodes >> are equal - what will happen if 2 sites update the same data? You >> could end up with a database inconsistency. >> >> If both sites are already connected via VPN tunnel though, couldn't >> you just point both applications to the same database using >> routing/firewall rules? Have 1 site be authoritative, have the other >> site be a read-only copy that activates in case the VPN goes down. >> >> 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. >> > -- >> > 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 >> > >> >> >> >> -- >> This email is: [ ] actionable [ ] fyi [ ] social >> Response needed: [ ] yes [ ] up to you [ ] no >> Time-sensitive: [ ] immediate [ ] soon [ ] none >> _________________________________________________ >> 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
