Where can I find a step-by-step guide to server architecture and configuration?

Question

MySQL

I'll try to formulate the question more specifically ... I have a MySQL database with rarely (every six months) changing data (mainly SELECT), and I use MongoDB as the main database. The server is written in NodeJS + cluster, as a proxy and for statics I use Nginx. Everything is still spinning test, analytics is being collected for the subsequent assessment of what data is often used, how best to scale, etc., but in the future I would like to correctly configure everything for production. The question is - are there step-by-step guides on the network for armor-piercing and valid server settings, which would include:
- setting up ports
- setting up static distribution
- setting up a database (indexes, scaling)
- general security configs
- examples of connecting to a database
- setting up a mail server
- setting up monitoring (such as an admin panel)
- installing and configuring HTTPS
- examples of NodeJS + MongoDB + Redis friendship
- etc ...
In short, I would like to get an adequately configured server, protected from typical attacks and scalable horizontally.

Answer 1

In an ideal world, at least 2-3 people should be involved in this, each in their own specialization: server admin, admin / specialist for the databases you use, etc.
In the real world, this is usually done by 1 or 1.5 people.
And no, there are no such guides.
Because all this is configured separately, not to mention the fact that setting up a specific database for normal operation or the server itself are generally different things and require different knowledge.
Everything is googled and configured separately as needed.
And also, as a rule, you always need to choose between several solutions for one task, because options for setting/soft wagon and small cart.

Answer 2

Start with this: https://debian-handbook.info/browse/stable/