Server to a MySQL database for a mini-mini-hayload?

What serwaczak to take Basco for aaaaaaaaaarghhh of hayload? (Especially for MP.bacon favorite)
Well what can you say about the base. Regular base with 10 tables. Tables of all kinds. Table with users, content, etc.

Which server to take the host? The V-world or the physical server? What is more important RAM, CPU, disk? Or all together or a few factors.

Well optimized database indexes and other crap.

The backend should be on the same server with the database, or they can be geographically delineate? Suppose in different countries to place. Will there be some big delay due to a network or not?

How do other projects? As they keep a few servers with a backend and multiple servers with the database?
April 19th 20 at 12:00
2 answers
April 19th 20 at 12:02
Any VPS for$ 5 Or verbalize specifically about the load, and then again it turns out how about a DDoS on the website is not and about the game, which is also why it is not.
Zaregalsya 50000 users online permanent 1000 people. On the website people click "play" and search selects 2 people, they make 10 numbers from 1 to 100, and the server generates 10 random numbers. After 1 hour, the system plays the prize. The income comes from advertising and a prize. the Foundation is there and appears.
Wins the one who has the product of the numbers closer to the product of the numbers of the server. To play, one must view several commercials. - Dean59 commented on April 19th 20 at 12:05
@Dean59, and where is the hint at least at some hailed, even mini-mini. So again, any VPS for$5
PS and immediately obvious that this made-up numbers. - Katelynn.Koch commented on April 19th 20 at 12:08
@Faith.Koch, fuck the numbers. Server for 5$ won't pull, as you and I would not like.
You're better than the real server name - Dean59 commented on April 19th 20 at 12:11
@Dean59, again, you now have no such service, you must first take and write it, then post on the cheapest VPS doing load testing, the result is simply apaesh the capacity of VPS to the next plan if this is certainly required. Your imaginary figures stand VPS for$5. - Katelynn.Koch commented on April 19th 20 at 12:14
@Dean59,
Server for 5$ won't pull, as you and I would not like.

I have a project that handles about 8 thousand simultaneous connections and works with a 37 GB database, the biggest table which has 23 billion records. But it's not hayload. And it is enough VPS'key for$10. - Carmelo_Schaefer28 commented on April 19th 20 at 12:17
@Carmelo_Schaefer28, well, not for$ 5), And certainly not in Russia with such prices. - Dean59 commented on April 19th 20 at 12:20
@Dean59, so tired, get selected for a lot of dough, still you do not overpower to do something, the usual chatterbox. - Katelynn.Koch commented on April 19th 20 at 12:23
@Dean59, well, if my load cut to your own, and batibasaga to be missed with a head miss. By the way, I was just in Russia. - Carmelo_Schaefer28 commented on April 19th 20 at 12:26
@Faith.Koch, for a lot will not. Dev to start 1-1.5 to RUB Will monitor load, MB and then move to a more powerful server. Then on a piece of metal, then it will cut the load on the server. - Dean59 commented on April 19th 20 at 12:29
@Carmelo_Schaefer28, hoster what? What you have drawn in Russia, and even for 10 bucks? - Dean59 commented on April 19th 20 at 12:32
@Dean59specifically this project on DigitalOcean spinning. It's not from a hosting. it depends on straightness of hands of the developer. - Carmelo_Schaefer28 commented on April 19th 20 at 12:35
@Carmelo_Schaefer28, Yes, of course. I asked about the country of the host. Talking about Raska
By the way, I was just in Russia.

Now, talking about DO
this particular project revolves on DigitalOcean.
- Dean59 commented on April 19th 20 at 12:38
@Dean59,
well, not for 5$) And certainly not in Russia with such prices.

I meant that I live and work in Russia, but for me it is not difficult to pay monthly about 450 bucks for hosting all my projects. The professionals are able to hayload well paid ;)

If you are interested in Russian hosters, some of my projects (with loads greater than you have stated) operating servers firstvds.ru, flops.ru and locum.ru.

Again, if the arms are straight, any of the well known hosters can handle it. - Carmelo_Schaefer28 commented on April 19th 20 at 12:41
April 19th 20 at 12:04
JOINов for the database and indices are more important than Prots, memory, and nvme secondary

Vultr look ( can repke in my signature, or this give 100 credits), there is CPU instances, cheaper Amazon , 10G network, and the like nvme drives already
pick up until you're pulling, then you can look for optimization, but Vultr norms channels, better Hetzner

Find more questions by tags Hosting