How can I increase ndbcluster performance ? - François Conil - com.mysql.lists.cluster

4 messages in com.mysql.lists.clusterHow can I increase ndbcluster perform...

From	Sent On	Attachments
François Conil	21 Jun 2005 08:28
Mikael Ronström	21 Jun 2005 11:13
F. Conil	21 Jun 2005 23:22
Mikael Ronström	22 Jun 2005 15:19

Subject:	How can I increase ndbcluster performance ?
From:	François Conil (con...@ece.fr)
Date:	06/21/2005 08:28:30 AM
List:	com.mysql.lists.cluster

Hi,

I'm currently using a ndbcluster to serve dns records via dynamic loadable zones, but the main problem is that I can barely serve 35-45 queries per second.

I already optimized the ndbcluster by setting indexes, going from 2-3 queries per second to the number I have now, but it's still not enough in regard of the performance I'm aiming for (mainly loading the records from the cluster).

Is there any way I can configure the cluster to increase its performance ? I tried to look for a solution, but it seems the only way to do so is to ditch the cluster and go the replication way... Maybe I didn't configure the memory usage the optimal way, or the processor usage, or whatever, so if someone has an idea to help me, it will be appreciated.