MySQL Forums
Forum List  »  Replication

Re: Two master databases for two seperate apps
Posted by: Rick James
Date: December 11, 2011 02:13PM

> queries will not work well on NDB cluster

> Our database tables are MyISAM bound.

Latency between continents is a fraction of a second per SQL statement. Are you issuing lots of statements? Would calling a Stored Procedure cut back significantly on the number of SQL statements that suffer the cross-ocean lag?

Personally, I feel that the hassles of multi-master (for MyISAM) to be worse than the delays.

Options: ReplyQuote

Written By
December 05, 2011 02:36PM
Re: Two master databases for two seperate apps
December 11, 2011 02:13PM

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.