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: Rick James ()
Date: December 11, 2011 02:13PM

> queries will not work well on NDB cluster
Why?

> Our database tables are MyISAM bound.
Why?

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


Subject Views Written By Posted
Two master databases for two seperate apps 975 Irfan Ali 12/05/2011 02:36PM
Re: Two master databases for two seperate apps 459 Daniel Mahoney 12/06/2011 05:10PM
Re: Two master databases for two seperate apps 471 Irfan Ali 12/07/2011 07:37AM
Re: Two master databases for two seperate apps 458 Daniel Mahoney 12/07/2011 08:33AM
Re: Two master databases for two seperate apps 427 Irfan Ali 12/07/2011 11:15PM
Re: Two master databases for two seperate apps 388 Rick James 12/09/2011 12:25PM
Re: Two master databases for two seperate apps 420 Irfan Ali 12/10/2011 02:37PM
Re: Two master databases for two seperate apps 462 Rick James 12/11/2011 02:13PM
Re: Two master databases for two seperate apps 437 Irfan Ali 12/12/2011 01:21AM
Re: Two master databases for two seperate apps 426 Irfan Ali 12/16/2011 05:49AM
Re: Two master databases for two seperate apps 378 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.