MySQL Forums
Forum List  »  NDB clusters

3 different architectures - best perfromance and redudancy?
Posted by: Peter Aschenberg
Date: April 17, 2005 07:55AM

Hi all,

first of all: sorry for my bad english - I try my best.

I tested MySQL-Cluster with different Configurations. It works really fine without any problems. But I am not sure which of following three configurations will be the best for my purposes.

The MySQL-Cluster solution will be used for an Web-Application - most important things, which must be assured by the database, are high availibilty, redundancy and scalabilty. Perormance is not that important at the moment. I would prefer a solution where the data is directly stored to disk - not only to memory, but I don't have enough time to wait for a stable release of MySQL-Cluster 5.1, where the direct disk storage will be supported, as I read. So I reduced the time/data amount between local checkpoints and global checkpoints, because we don't have much INSERTs at the moment - Working perfectly.

Available Hardware for the MySQL-Cluster and the Web-Application:
==================================================
Server1 and Server2 - both: 1 x 2,8 Ghz, 2 GB Memory, 1 NIC 100 Mbits, 1 NIC 1000 Mbits, normal power supply
Server3 and Server4 - both: 2 x 1,6 Ghz, 2 GB Memory, 2 x 100 Mbits NIC, redundant power supply
Server5: 1 x 2,4 Ghz, 1 GB Memoty, 1 x 100 Mbits NIC, normal power supply)
1 x Alteon AD4 Loadblancer


Setup 1:
==================================================
Server1, Server2: NDB-Storage-Nodes
Server3, Server4: Webapplication and MySQL-Nodes
Server5: Management for the Cluster

The Alteon Loadbalancer balances the http and https requests to Server3 and Server4 where the WebApplications are hosted. Both Servers are also MySQL-Nodes, so that the Applications make MySQL-Requests to "localhost". The MySQL-Nodes automatically balance the Requests to the NDB-Storage Nodes (Server1 and Server2.)


Setup 2:
==================================================
Server1, Server2: MySQL -Nodes and NDB-Storage-Nodes
Server3, Server4: Webapplications
Server5: Management for the Cluster

The Alteon Loadbalancer balances the http and https requests to Server3 and Server4 where the WebApplications are hosted. For MySQL-Requests a balancing/virtual ip of the loadbalancer is used, which balances the Requests to Server1 and Server2.


Setup 3:
==================================================
Server1, Server2, Server3, Server4: Webapplications, MySQL-Nodes and NDB-Storage-Nodes on all servers (Server1 and Server2: nodegroup1, Server3 and Server4: nodegroup2)
Server5: Management for the Cluster

The Alteon Loadbalancer balances the http and https requests to to all four Servers. Each of this Servers requests "localhost" for MySQL.


Which of the above configurations is the best for my purposes? I am not sure at the moment. All of them have advantages and disadvantages.

One more question: Is there a possibility for setup1 and setup2 to connect Server1 and Server2 with a crossover-cable to get a 1000Mbits Connection. I think this would make sense, because of the traffic caused by reducing variables for checkpointing.


Thank you a lot in advance!

best regards from germany

Options: ReplyQuote


Subject
Views
Written By
Posted
3 different architectures - best perfromance and redudancy?
5809
April 17, 2005 07:55AM


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.