Re: Cluster performance

[Johan Wikstrom]

Hi Mikael,
Thanks for your quick response. We upgraded the second nodes hardware from:

Intel Pentium III 550MHz
396 MB RAM

to

AMD Athlon 1,4 GHz
650 MB RAM

.... and the cluster performance was MUCH better. Is that because the hardware was unbalanced or because the hardware in the first case was way to week for a MySQL cluster (even in a lab env)?
Should you always try to have balanced nodes in a MySQL cluster?

Further, is the table type MyISAM 2x faster then NDB? Can we do any thing to speed up NDB?

>Using 5.0 is also likely in general to speed up your IN queries
>significantly upto 3-4 times.

This sound really interesting! Are you still developing MySQL 4.1.x, or are you just working on bug fixes for that version? Is all focus from the development side on 5.x?

Is there any drawback running MySQL 5 with PHP 4, compared to MySQL 4.1?

Do you recommend us to do any changes in the config.ini or anywhere else in the cluster to get better performance?

Thanks in advance.

Kind regards,
JW