Re: Setup for perfromance?

[Harrison Fisk]

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.