Re: How many each nodes do I need for mysql 5.0 cluster - Jonathan Miller - com.mysql.lists.cluster

3 messages in com.mysql.lists.clusterRe: How many each nodes do I need for...

From	Sent On	Attachments
박종세	29 May 2008 14:23
Jonathan Miller	29 May 2008 14:36
Massimo	29 May 2008 14:53

Subject:	Re: How many each nodes do I need for mysql 5.0 cluster
From:	Jonathan Miller (jmil...@mysql.com)
Date:	05/29/2008 02:36:10 PM
List:	com.mysql.lists.cluster

Hi,

Do you have one host (computer) or multiple hosts with the below hardware?

I assume that you are wanting to move to Cluster for HA.

To have HA you would need at least 3 hosts.

2 for data nodes 1 for MGM and MySQLD

Now as for scaling and the number of DN or MySQLD's you need is a questions that has many questions needing answered first.

DB Schema(s)? Transaction schema(s)? Disk Speed Memory Speed Network Seed etc...

Best rule of thumb is to watch the CPU usage for the processes. If your MySQLD is maxing out, but your data nodes are not, then you would need to add additional MySQLD Demons.

Usually what you will find it that NDBD will not be terribly taxed and by adding additional mysqld's you can scale to more transaction.

The other item you will need to consider is a load balance of some type for the MySQLD processes.

My best suggestion to you is to use test hosts and simulate and ensure of configuration before you migrate.

None the less, ensure that you have a good backup of your data before you start ;-)

-- Best wishes, /Jeb

Jonathan Miller Cluster Lead QA Developer Certified Cluster Database Administrator Sun Microsystems / MySQL Austin, Texas US www.mysql.com www.sun.com

I'm Certified, are you? http://www.mysql.com/certification/index.html

박종세 wrote:

I'm planning to move mysql 5.0 to mysql 5.0 cluster. I used ndb_size.pl to calculate ndbd memory size needed for mysql 5.0 cluster;

---------------- Parameter: 5.0 DataMemory (kb): 10863744 IndexMemory (kb): 440848 MaxNoOfTables: 710 MaxNoOfAttributes: 11593 MaxNoOfOrderedIndexes: 3461 MaxNoOfUniqueHashIndexes: 3461 MaxNoOfTriggers: 13844

-----------------

There are 10000/sec concurrent users on specific (pick) time in this service. So I want to know numbers of ndbd nodes and sql nodes for my system. How many SQL nodes I need? How many NDBD nodes I need? computer has 2 CPU, 16RAM.

Please I need your help

Thanks