MySQL Forums
Forum List  »  NDB clusters

Re: SQL Cluster hardware/software questions
Posted by: Adam D
Date: July 26, 2005 05:25PM

Leon Croese wrote:

> (1) the SQL node is place where incoming SQL
> queries come in and the SQL node performs the
> query at the SQL Cluster and return the results?
> Is this correct?

The SQL Node is just that, a MySQL server of which accepts connections and queries as per normal MySQL operation. The grunt work is magically split up between the datanodes, and the SQL nodes, I think the SQL node does most of the ORDER BY work etc with non index'ed stuff, and the data nodes do what they can and split the load up.

> (2) the Management node is only used to manage the
> SQL Cluster like starting, stopping, backups etc?

Yes.

> (3) the Data node is place where the data is
> actually stored I assume?
Yes.

> (4) Can we combine the SQL and data node to 1
> server?
I believe you can do this, however your MySQL nodes will have an impact on your available RAM. This is a consideration I am currently playing with.

> (5) Can we combine the Management and SQL node to
> 1 server?

Yes, This is what I have at the moment. Runs fine - Im still in testing at the minute though.


> (6) what are the hardware requirements for each
> node? The data node should be scsi and a lot of
> RAM installed but should the SQL and Management
> nodes be the same or can they run without lots of
> RAM etc?

Requirements differ depending on your database construct. How many tables with how many fields and how many rows. I wish there was a definative way to calculate this, someone else may be able to provide better info than I. I found a good calculation to factor amounts of RAM required;
(SizeofDatabase * NumberOfReplicas * 1.1 ) / NumberOfDataNodes


> (8) Does anyone has already the MySQL Cluster
> running with FreeBSD as I read it is not official
> supported?

I have FreeBSD 5.4 systems for my MySQL cluster at the minute. Works fine and without complication. However with large memory per process requirements I did need to place a value such as this in the /boot/loader.conf
kern.maxdsiz="1872864000" # Set the max data size
That allows a process to grow up to 1.8gb or just under in memory allocation.

However I am seriously considering moving to RHEL4.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL Cluster hardware/software questions
1959
July 26, 2005 05:25PM


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.