Where is the best place to host a database server?

Question

Network administration

I'm going to launch the site in production and I don't know how best to deal with the database, in which I already have little or no experience. Is it right to host the database server next to the site server or is it better to make it remote on other hostings. If the second then advise hosting for these purposes.

Answer 1

This is a hundred times premature optimization. Start with localhost.

Answer 2

Of course, you need to start with localhost'a. Then, with a strong increase in load, you can transfer it to another server, but:
1. This is justified only with a really heavy load in order to increase performance. For many relatively large sites, this is not necessary at all.
2. It must definitely be in the same data center of the same hosting as the site files. So to speak, a neighboring server. Because the greater the distance between data centers, the more you lose in data exchange speed. And for an exchange with a DB it is critical for speed. Therefore, moving the database server to another hosting is a performance degradation.

Answer 3

If the site is small, then a separate server will probably be redundant. You need a simple hosting that provides good performance of the disk subsystem.
On the other hand, I’m most interested in which hosting providers will be advised specifically for the database server

Answer 4

it's all marketing , a normal VPS on the same OVH without oversells will come out cheaper