MySQL Forums
Forum List  »  Newbie

Re: design distributed database
Posted by: Sukruthi K . S
Date: December 30, 2009 11:56PM

yes Rick you are correct.100k users is like u and i are users.And i am sure of the application being accessed by 100k users/sec.And these 100k users load would be distributed to different mysql server in cluster(the exact number of distribution is yet to be determined).

Depending on the web page selected from application ,the queries range from simple single row select to selecting 3K rows from 1M Records and 10 such queries/sec/user for a single click on a web page.If suppose i have a connection pool and users share from this connection pool.Then comes again the same point - how many connections can be created by mysql server and how is the response time if all connections are utilized simultaneously to select 3k rows from 1M Records.

Options: ReplyQuote


Subject
Written By
Posted
December 22, 2009 07:04AM
December 23, 2009 11:32PM
December 30, 2009 04:54PM
Re: design distributed database
December 30, 2009 11:56PM
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.