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 945 Irfan Ali 12/05/2011 02:36PM
Re: Two master databases for two seperate apps 447 Daniel Mahoney 12/06/2011 05:10PM
Re: Two master databases for two seperate apps 453 Irfan Ali 12/07/2011 07:37AM
Re: Two master databases for two seperate apps 447 Daniel Mahoney 12/07/2011 08:33AM
Re: Two master databases for two seperate apps 407 Irfan Ali 12/07/2011 11:15PM
Re: Two master databases for two seperate apps 376 Rick James 12/09/2011 12:25PM
Re: Two master databases for two seperate apps 402 Irfan Ali 12/10/2011 02:37PM
Re: Two master databases for two seperate apps 448 Rick James 12/11/2011 02:13PM
Re: Two master databases for two seperate apps 425 Irfan Ali 12/12/2011 01:21AM
Re: Two master databases for two seperate apps 409 Irfan Ali 12/16/2011 05:49AM
Re: Two master databases for two seperate apps 371 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.