What are the pros and cons of hosting a database on a remote server?

Question

PostgreSQL

I want to transfer the database to a separate server so as not to consume the resources of the main server.
When I performed project tasks from a laptop, the read and write speed was so-so. I understand that my home Internet channel is very different from the DC channel, but still.
In general, please write the pros and cons of this approach.

Answer 1

I understand that my home Internet channel is very different from the DC channel, but still.

it is not so much the "thickness" of the channel that is important, but also its "length". And here, the shorter the better. If both of your servers are located in the same data center, then most likely the "ping" to the server with the base will be within 1ms, which is acceptable. Especially if you do not often break connections with the base.
Pros:
- database on a separate server, it becomes possible to scale the database server vertically.
- horizontal scaling (replication, read-only replicas, for example, to speed up reading)
- two medium servers usually cost less than one powerful one.
Cons:
- Well, you need to do it, configure, tune ...
- Additional costs for additional servers. And most likely you will want to have another server "as an alternate airfield".