1 message in com.mysql.lists.clusterRe: MySQL Cluster Question in Froum: ...| From | Sent On | Attachments |
|---|---|---|
| Stewart Smith | 16 Jun 2006 00:53 |
| Subject: | Re: MySQL Cluster Question in Froum: Recommended Server Spec |
|---|---|
| From: | Stewart Smith (stew...@mysql.com) |
| Date: | 06/16/2006 12:53:47 AM |
| List: | com.mysql.lists.cluster |
On Wed, 2006-06-14 at 17:16 +0800, Hisyam A Halim wrote:
I'm very much interested in MySQL cluster, i appreciate it if u can clarify my confusion in the forum.
The message looks familiar - already answered? or did it drop off the radar?
I'm starting a project that requires HA & high throughput. I've read the MySQL 5.1 Ref Manual Chapter 17.3 that suggests a 4 server setup
Server 1 Manamagement Node Server 2 MySQL Server Node Server 3 Data Node A Server 4 Data Node B
I've also read in the various posts that it is recommended to run the MySQL Server on all nodes to load balance the access to the cluster so the setup would be
Server 1 Manamagement Node + MySQL Server Server 2 MySQL Server Node Server 3 Data Node A + MySQL Server Server 4 Data Node B + MySQL Server
This means that I could alternate my JDBC access to the 4 servers to load balance the queries.
Questions? 1. Assuming I can buy dual processor machines which servers should have dual processors? (e.g. Server 3 & 4)
all.
2. Is it better to have a dedicated MySQL Server Node? Or can I just get rid of Server 2?
you generally need several mysql server nodes to load up the data nodes. the more the merrier.
3. Which servers should I allocate more RAM?
all. mysql server can use for buffers, query cache. ndbd can use it for datamemory and indexmemory.
4. MySQL Cluster is an on-memory DB where all the data sits in memory. So why does the MySQL Cluster FAQ (http://www.mysql.com/products/database/cluster/faq.html) recommends very large hard disk space (i.e. 4x 36GB SCSI (RAID 1 Controller)?
checkpointing, backups.
btw a few 36GB drives is not big :)
5. Which server should have more hard disk space?
data nodes. for checkpoints, backups etc.
-- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66...@sip.us.mysql.com Mobile: +61 4 3 8844 332
Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html