Re: Two master databases for two seperate apps
Posted by:
Irfan Ali
Date: December 10, 2011 02:37PM
Hello Rick,
NDB Cluster might not suite for us because of database queries will not work well on NDB cluster. Our database tables are MyISAM bound.
As i described earlier, we have two websites hosted in asia and eurose DC and both sites are in sync with each other.
Currently we have only one master database in Europe DC which is synchronizing underlying slaves on Asia and Europe DC. Asia DC and Europe DC connects to slaves for read only queries locally.
To eliminate WAN link from asia DC to Europe DC master database for write purposes and to eliminate replication delays on Asia site, we decided to both site will write data locally and will synchronize each other via bidirectional replication. I foresee this will improve asia site performance as well.
We will resolve conflicting issues on app level to prevent replication break between both master databases. Our database tables are MyISAM bound. And because of that i foresee queries get block because of single threaded replication as both masters are slaves at same time so might be we will not achieve desire results and this might produce replication delays on both DC on masters and underlying slaves
.
But still i have only this solution in mind to speedup asia site performance. Can you please provide some feedback on multiple write masters. Also is there any automated tools available to resolve conflicting issues.
Overall please comment on this architecture and advise.
Subject
Views
Written By
Posted
2001
December 05, 2011 02:36PM
789
December 06, 2011 05:10PM
840
December 07, 2011 07:37AM
878
December 07, 2011 08:33AM
845
December 07, 2011 11:15PM
792
December 09, 2011 12:25PM
Re: Two master databases for two seperate apps
789
December 10, 2011 02:37PM
845
December 11, 2011 02:13PM
777
December 12, 2011 01:21AM
798
December 16, 2011 05:49AM
698
December 17, 2011 12:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.