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/