MySQL Forums
Forum List  »  NDB clusters

Re: Cluster Design
Posted by: Jonathan Stephens
Date: November 21, 2006 12:34AM

Note that we recommend even powers of two for the number of data nodes (2, 4, 8, 16) and replicas (1, 2, 4). We also recommend that you *don't* run other processes on the data node hosts.

For your larger case, I think you'd get better results with 4 or 8 data nodes with lots of CPU and memory, a couple of less bulked-out machines for the SQL nodes, and a couple cheap low-end boxes for the management nodes (a 400 MHz CPU and 256 MB RAM is fine for an MGM node running on a no-GUI Linux machine).

Of course, there's nothing wrong with running ndb_mgmd's and mysqld's on the same machines but for production use, just make sure you've got at least two of each and that you don't have all of the management nodes or all of the SQL nodes running on the same box.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
1807
November 17, 2006 08:54AM
Re: Cluster Design
1196
November 21, 2006 12:34AM


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.