MySQL Forums
Forum List  »  NDB clusters

Re: Setup for perfromance?
Posted by: Harrison Fisk
Date: December 04, 2004 04:40PM

Hi,

A few rules of thumb:

1. Network latency is very important for performance. SCI is much better than gigabit ethernet in this regard.

2. More API nodes than DB nodes. You will almost always want to have more API nodes than DB nodes in order to add more concurrency. Normally up to twice as many API nodes will continue to increase over throughput. You can quite often run them on the same machine in order to increase their numbers.

3. NoOfReplicas is important for performance as well. If you increase this, it will give you more copies of data, which increases the HA properties, but can cost quite a bit of performance. Normally you will want a setting of 2, which is a good trade off.

Finally it is worth mentioning that newer releases have many more optimizations as well. I would recommend testing 4.1.7 or 4.1.8 when they come out. There have been many enhancements in the last few releases of how MySQL Cluster can do things in parallel. 5.0 will be even more enhanced in the same way.

As far as Oracle RAC vs. MySQL Cluster, they are quite different in how they work (shared-storage vs, shared nothing) and have different pros and cons as a result.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com



Edited 1 time(s). Last edit at 12/04/2004 04:42PM by Harrison Fisk.

Options: ReplyQuote


Subject
Views
Written By
Posted
3900
December 04, 2004 08:17AM
Re: Setup for perfromance?
2735
December 04, 2004 04:40PM
2721
December 05, 2004 09:14AM
2592
December 05, 2004 06:28PM
2317
December 05, 2004 07:25PM


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.