MySQL Forums
Forum List  »  NDB clusters

Re: Cluster performance
Posted by: Johan Wikstrom
Date: May 30, 2005 03:21AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3275
May 27, 2005 04:32AM
2410
May 27, 2005 12:50PM
Re: Cluster performance
2386
May 30, 2005 03:21AM
4171
May 30, 2005 09:46AM
2475
June 02, 2005 04:19AM
2368
June 02, 2005 07:04PM
2285
June 03, 2005 11:06AM
2433
June 08, 2005 08:50AM
2068
June 03, 2005 12:26PM


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.