MySQL Forums
Forum List  »  NDB clusters

Re: extremely high context switches and interrrupts
Posted by: Jonathan Miller
Date: April 13, 2006 10:34AM

Hi,

One needs to understand the was a distributed system works. Cluster will not be as fast as your MyISAM was. This is due to all the network traffic that has to happen between the NDBD nodes in order to insure HA.

But one can take steps to reduce the perfromance hit.

Examples,

Allow the data nodes to do their COMM to other DN on a different network/NIC.

Ensure not to run both data nodes and MySQLD processes on the same box.

Dedicate the box to Data Nodes (i.e. no other application running on the box)

You will find that you can add many MySQLD processes and still not max out the datanodes.

To become really productive using cluster, I would suggest looking at:
http://www.mysql.com/training/courses/mysql_cluster.html

Thanks!

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
Re: extremely high context switches and interrrupts
1512
April 13, 2006 10:34AM


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.