MySQL Forums
Forum List  »  NDB clusters

Re: NEED help to fix cluster design issue of 40 terabytes
Posted by: Naveen Chhibber
Date: December 19, 2006 11:03PM

Dear

1. Can You give me some Vender Name for such big RAM.

2. Design we are going for is

there is need of 24x7x365 days availablity for telecom sector

there are 600 Tables

each having approximately 17 fields

one of 17 fileds one field is blob that may go upto 2KB

Remaining 16 fileds may be of 150 bytes and all 16 fileds are indexed and there is one is primary key in each table

incoming transactions are 15000 / sec which will be distributed in these 6 tables at a time.

we will drop all indexes at the time of insertions and after insertions we will create indexes on it. then we will apply select queries accordingly that may be on all tables. Select queries load will be low but it should be effecient enough that it may not irritate operators.

Now please suggest how much RAM we should take and how many nodes should be there


3. Using 5.1 in this case my be safe or not because it is beta version

4. if we use 5.1 the blobs may be on disk then in that case ram required will be too much low

5. even then it may be more than 3 TB total.

Regards

NAveen

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: NEED help to fix cluster design issue of 40 terabytes
1065
December 19, 2006 11:03PM


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.