Infrastructure for high loads

0 like 0 dislike
7 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 | 7 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
Advise the book on SQL, Python, optimization for high loads?
asked Mar 26, 2019 by 3ds
0 like 0 dislike
5 answers
Good resources for setting up High Load servers + nginx on the Trix?
asked Mar 26, 2019 by Amadeusck
0 like 0 dislike
2 answers
How to implement the guaranteed execution of operations on the server under heavy loads?
asked Apr 5, 2019 by likejavascript
0 like 0 dislike
1 answer
Optimization of high-load applications. C++. What literature advise to read?
asked Jun 8, 2019 by hydra_13
0 like 0 dislike
3 answers
How to choose a Python framework for high-loaded web application?
asked Apr 1, 2019 by theaidem

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
1,116 users