MySQL Forums
Forum List  »  Newbie

Re: design distributed database
Posted by: Rick James
Date: December 23, 2009 11:32PM

Well, sounds like you need at least 50 machines of that size, with the data "sharded" among the machines.

Please give some more details; there are lots of things that can impact the design.
* What will the SELECTs be like?
* How will be the data inserted?
* SHOW CREATE TABLE tbl\G -- engine, indexes -- your estimate of size needs more scrutiny, and possible optimization.

100k concurrent connections -- elaborate. Usually connections are idle. 2000 connections per machine would involve a lot of RAM. By disconnecting at appropriate times, you might not really have 100K.

Are the specs flexible? That is, might you purchase more RAM or more disk space? Without the details, it is hard to say which, if either, would be worth increasing. (Adding more cores is not likely to be useful.)

Options: ReplyQuote


Subject
Written By
Posted
December 22, 2009 07:04AM
Re: design distributed database
December 23, 2009 11:32PM
December 30, 2009 04:54PM
December 31, 2009 02:52AM


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.