MySQL Forums
Forum List  »  NDB clusters

Re: Cluster performance
Posted by: Jonathan Miller
Date: June 08, 2005 08:50AM

Anton,

One of the developers resond to these questions:

To improve performance for cluster he first of all has to parallellize his application so that is uses

0. not to get up to myisam speed (unless he makes his application much
bigger)
1. several client connection to the mysql server, running in parallell threads 2. preferably have those clients being able to run towards several mysql servers 3. moreover look over the application for complex joins...

60-600 time performance issues are not solved by moving nodes around..., but since it seems he loads the mysql server heavily, it might be a good idea to have it colocated with the ndbd nodes rather than his application (all depending on his hardware availability...)

Jonathan Miller
Austin, Texas USA
Senior QA Developer

MySQL AB www.mysql.com

Jumpstart your cluster!
http://www.mysql.com/consulting/packaged/cluster.html

Get training on clusters
http://www.mysql.com/training/courses/mysql_cluster.html

All-in-one Enterprise-grade Database, Support and Services
http://www.mysql.com/network/

Options: ReplyQuote


Subject
Views
Written By
Posted
3275
May 27, 2005 04:32AM
2409
May 27, 2005 12:50PM
2386
May 30, 2005 03:21AM
4170
May 30, 2005 09:46AM
2474
June 02, 2005 04:19AM
2366
June 02, 2005 07:04PM
2284
June 03, 2005 11:06AM
Re: Cluster performance
2432
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.