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: 6616 sip.us.mysql.com
Mobile: +61 4 3 8844 332
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
|