Hi Jan, On Sat, Feb 20, 2010 at 3:13 PM, jan gestre <[email protected]> wrote: > 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. You have to be doubly sure of this. Just because the applications are not updating the same data, doesn't mean they can't end up giving you a corrupt db. You have to double check with your developers if their transactions are "logically" atomic.
If they are, I think it's possible to take advantage of mysql's general query log to tell the remote sql server to execute queries it hasn't "yet" done. You're going to have to script for each server to find out it's current progress in the other's logs. However, DELETEs, in general, will cause you trouble, because there's no way for the offline server to know that such and such items aren't supposed to exist anymore. > > 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 > -- 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
