Infrastructure for high loads


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/code-flow.club/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
13 views
Good afternoon, colleagues. Preparing to launch one project, unfortunately, the NDA I can't tell what is the project late, after the start, write a post, but there was a problem.

By the time of launch, we expect high load and we are a little difficult to assess the necessary infrastructure for them. At the peak, we expect ~5 million MySQL queries per minute (60% Select / 40% Insert). The query itself is quite simple i.e. without complex samples, etc. please Tell me the equipment that it all digest. We were offered 2 8 gigs core 2 Duo for web and 3 8 gigs core 2 Duo under the database.

Thanks in advance
by | 13 views

7 Answers

0 like 0 dislike
Processor you never will be the bottleneck, the database will immediately abut the disk.
If the three servers so there is some load balancer, or used by sharding the data?
What is the volume of the base and it? Number of records on the plates, at least about 1-20G,20-50G,100G
Is there some caching in addition to the query cache in mysql
\r
100% everything upresa immediately to disk, especially on simple samples.
If the load is really that which you described, 4x 32G SSD Intel X25e RAID10 + 4 cores + 16/32 operatives. Then there is a chance that vzletit, after careful tuning of mysql.
by
0 like 0 dislike
Guys and you have a job? ;-)
by
0 like 0 dislike
Simple sampling = the processor is almost never used.
Then it depends on the database size. If the commercials 20-30 gig take 32GB memory, cache almost all x2 and ssd's in raid1.
If the database is 50GB and more of the same, only x4 ssd and raid10.
\r
About web to say that it is difficult because it depends on what you have there and how it's written.
by
0 like 0 dislike
You can take cloud hosting and server load to the conclusion that it is worth to buy.
by
0 like 0 dislike
dig the first is in the direction of refusal from mysql. For such requests, perhaps even towards noSQL
by
0 like 0 dislike
If the losses are very serious, you can invest to port all of the Oracle.
If the money is not enough, you can carry everything in PostgreSQL, is it better Muscula scales.
Perhaps the combination of Postgres and noSQL databases.
by
0 like 0 dislike
this topic is similar to the guessing of the charades, so let's say what we're doing otherwise you nazovyom such that they themselves will regret it!
by

Related questions

0 like 0 dislike
6 answers
0 like 0 dislike
5 answers
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
0 like 0 dislike
3 answers
110,608 questions
257,186 answers
0 comments
22,957 users