Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Does anyone have any recommendations or know of any decent guides for a MySQL server infrastructure.

We are currently looking to implement a infrastructure that can handle 180+ queries per a second? This is from a hardware point of view (VMware based/CentOS VM).

share|improve this question

2 Answers 2

This is impossible to answer.
Pretty much any server can handle >180 q/s of SELECT 1; queries, but that is probably not what you want.

It highly depends on many factors.

Are all the queries sent to your server the same?
Only SELECTs or also changes of data?
Can you cache query results?
How big are your DBs?
How big are the results/changes?
Complex queries?
etc.

In the end you will need to benchmark this on your own.

share|improve this answer

benchmark, gather trending, experiment. if queries are index-based and 'touch' very few rows; if the index [or even better whole data set] fits in memory - you can handle much more requests per second.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.