Re: extremely high context switches and interrrupts
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/
Subject
Views
Written By
Posted
2360
April 12, 2006 09:47PM
Re: extremely high context switches and interrrupts
1512
April 13, 2006 10:34AM
1431
April 18, 2006 07:00AM
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.