Server for MySQL database for mini mini highload?

Question

MySQL

What servachok to take under the base for a little highload? (Especially for Mr. Bacon beloved)
Well, what can I say about the base. Normal basis on 10 tables. Tables of various kinds. Table with users, content, etc.

What server to take from the host? Virtual or physical server? What is more important RAM, processor, disk? Or all of this together or several factors.

The base is not bad optimized by indexes and other crap.

Should the backend be on the same server as the base, or is it possible to separate them geographically? Suppose to place in different countries. Will there be some big delay due to the network or not?

How are other projects doing? How do they keep multiple backend servers and multiple backend servers?

Answer 1

Any VPS for $5 Or be more specific about the load, otherwise it will again turn out to be both about DDoS on the site which is not there, and about the game, which for some reason is also not there.

Answer 2

for the base of JOINs and indexes, percents are more important, memory and nvme are secondary
Vultr look (you can follow my ref in the signature, or they give 100 credits for this one), there are CPU instances, cheaper than Amazon, 10G network, and like nvme disks already
pick up until it fits which pulls, then you can look for optimization, but Vultr channels are normal, better than Hetzner