Skip navigation links

MySQL Forums :: Replication :: Two master databases for two seperate apps


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
Two master databases for two seperate apps 1010 Irfan Ali 12/05/2011 02:36PM
Re: Two master databases for two seperate apps 473 Daniel Mahoney 12/06/2011 05:10PM
Re: Two master databases for two seperate apps 492 Irfan Ali 12/07/2011 07:37AM
Re: Two master databases for two seperate apps 481 Daniel Mahoney 12/07/2011 08:33AM
Re: Two master databases for two seperate apps 442 Irfan Ali 12/07/2011 11:15PM
Re: Two master databases for two seperate apps 406 Rick James 12/09/2011 12:25PM
Re: Two master databases for two seperate apps 450 Irfan Ali 12/10/2011 02:37PM
Re: Two master databases for two seperate apps 480 Rick James 12/11/2011 02:13PM
Re: Two master databases for two seperate apps 451 Irfan Ali 12/12/2011 01:21AM
Re: Two master databases for two seperate apps 442 Irfan Ali 12/16/2011 05:49AM
Re: Two master databases for two seperate apps 386 Rick James 12/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.