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
3359
May 27, 2005 04:32AM
2456
May 27, 2005 12:50PM
Re: Cluster performance
2431
May 30, 2005 03:21AM
4217
May 30, 2005 09:46AM
2523
June 02, 2005 04:19AM
2416
June 02, 2005 07:04PM
2325
June 03, 2005 11:06AM
2477
June 08, 2005 08:50AM
2100
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.