I have a problem that I am trying to wrap my head around, and I am hoping someone in this
group can help me. We have been testing cluster for a while now, and we have liked how
cluster has performed thus far. However, before we move into deploying cluster, I would
like to know the answers to a couple of scalability questions.
On our current system, we have 4 data nodes, and 2 mysqld nodes that run about 60,000
queries a minute. We expect our traffic to increase significantly over the next couple
of years, and I am look for some guides, or any source of information that will help
answer the following questions.
1. How can get a determination of how my cluster configuration is performing. Given my 4
data node, 2 mysqld nodes, 60,000 query a minute load, how close am I to impacting
2. Is there any benchmark data out there?
3. How do I know when/how to add nodes to the cluster? For example, what is the
deference between adding a mysqld node, and a data node, and how do I know when it would
be necessary to add either?
4. Is there any tips/procedures used to measure performance of cluster?
Thank for any help you can provide.
44965 Aviation Dr. Suite 400
Dulles, VA 20166
Office: (703) 996-2941
From: Dan Frincu [mailto:dfrincu@stripped]
Sent: Monday, July 26, 2010 12:38 PM
To: Ricardo Soares Guimarães
Subject: Re: Converting MyISAM with 300GB to NDB.
Try ndb_size.pl script on the 300GB database (it will take some time) to
get the settings necessary for NDB, however based on the amount of data
and the limited amount of RAM, unless you seriously upgrade your RAM and
add several servers in the equation, I don't see how this would be
achievable with this H/W configuration.
You might want to check out this link
Ricardo Soares Guimarães wrote:
> I have one database with 300Gb of data, and want to try NDB.
> That´s possible?
> I tried several configurations, and keys, but seems that can´t import
> such data
> My server has (now) 16Gb of RAM, but soon will have 32.
> Anyone tried such configuration?
> I am using mysql-cluster 7.1.x with 64bits linux server.
This e-mail and any files transmitted with it may be proprietary and are intended solely
for the use of the individual or entity to whom they are addressed. If you have received
this e-mail in error please notify the sender.
Please note that any views or opinions presented in this e-mail are solely those of the
author and do not necessarily represent those of ITT Corporation. The recipient should
check this e-mail and any attachments for the presence of viruses. ITT accepts no
liability for any damage caused by any virus transmitted by this e-mail.