MySQL Forums
Forum List  »  NDB clusters

Where to have the Server node / Is our hardware adequate?
Posted by: Mohammad ajjour
Date: November 09, 2006 08:17PM

Hi all

We run a php / mysql university system, the system seems to require 50 / 50 load in terms of the application ( PHP ) and the database, with traditional mysql.

Currently we have 2 application servers Daul Xeon 2.4 and 1 Database servers Daul Core Daul Xeon Woodcrest

But we have been faced by slow performance and even database connections being refused during registration periods.

We have been studying our options for a while and we have decided to move our database from a single machine to a cluster.

To have higher performance and lower failure risk

Our Database is about 400 MB expected to be around 1 GB in one to 2 years
We have both reads and writes with more reads

Still having some daughts where to have the MySql nodes

Our setup is as follows

1 GB network

3 Load balanced Application servers PHP / Apache ( One application 3 copies)
Intel Dual Core Dual Xeon Woodcrest 5130 2.0GHz Processors - 4 x 2MB Cache x 2 or 4 GB Ram

4 Data Nodes - Intel Dual Core Dual Xeon Woodcrest 5130 2.0GHz Processors - 4 x 2MB Cache x 2 or 4 GB Ram

1- What do you thing is this adequate to have high performance and reduce failure risks
2- Are the RAMS Enough?
3- And the big question, where to have the SQL Server nodes with the application servers or with the SQL nodes?


Scenario A

We thought of having the SQL nodes on the application servers so every PHP application will connect to its one server instance which will connect to the data nodes to do the job. This way requests on the SQL servers will be balanced, and if one server goes down its application could connect to the other applications server.

We do not know exactly what is the load ratio between the SQL nodes and the data nodes so we are afraid that the data nodes machines will end up having much less load than the Application /Server Machine.


Scenario B,

To have the SQL Server nodes with the Data Nodes, so all the Database effort will be on those 4 data / Server nodes.

This way we can downgrade the Application servers to
Intel Pentium D 930 - 2 x 3.0GHz Processors - 2 x 2MB Cache
2 GB ECC DDRII 667 Ram


But we have some concerns.

1- How to balance the connections from the application to the Sql Server. In addition to load balancing delay.
2- Wouldn’t this scenario put to much effort on the 4 data nodes.
3- Wouldn’t this require More RAM upgrades to the 4 data nodes.

Scenario C

To separate the SQL Server nodes to their own 2 machines, but in this case we will have to downgrade the database hardware to.

3 Dedicated Application Nodes
Intel Pentium D 930 - 2 x 3.0GHz Processors - 2 x 2MB Cache
2 GB ECC DDRII 667 Ram

2 Dedicated Sql server Nodes
Intel Pentium D 930 - 2 x 3.0GHz Processors - 2 x 2MB Cache
2 GB ECC DDRII 667 Ram

4 Dedicated Sql server Nodes
Intel Pentium D 930 - 2 x 3.0GHz Processors - 2 x 2MB Cache
4 GB ECC DDRII 667 Ram

1-We will still have the problem of how to load balance the from the application to the Sql Server. In addition to load balancing delay.
2- Wouldn’t this add network latency since we will have three tiers.


Thanks for your contribution.
M. Ajjour

Options: ReplyQuote


Subject
Views
Written By
Posted
Where to have the Server node / Is our hardware adequate?
1528
November 09, 2006 08:17PM


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.