How to choose components for a home server?

Question

linux

There is a certain project, a server is needed for it, on which the Mysql DBMS will be installed, the server part of the project itself (receives information / files, writes / makes a selection from the database, gives information back). What parameters should be taken into account first of all? I think that the main thing to pay attention to is the speed of hard drives and RAM. Am I right?
How powerful does the configuration need to be to handle loads of, say, 200 - 500 - 1000 concurrent connections? I apologize right away for amateurism, but if you assemble a very budget computer server for 10-15 thousand rubles, then how many approximately simultaneous connected users can it handle? And another question, is the game worth the candle or is it better to use VPS / VDS?
FreeBSD OS, backend in Python, followed (if successful) by a "move" to C++/Qt or C++/Boost.

Answer 1

If there are no too specific requirements, then assembling it yourself is not an option. Rent. Your server has a much higher TCO. At home, it is very noticeably higher, taking into account the power reserve, network, depreciation (do not forget to count too!) And the replacement of failing components.
As it gets crowded, you can rent another car.
I advise you to start with VPS - it is easy and simple to increase resources as the project develops.
Regarding the load - the very presence of the question suggests that even up to a hundred rps is very far away. Otherwise, the question would not have arisen at all and it would have been self-evident that everything depends on the specific project, how the architecture and specific code (and you will also see specific monitoring graphs, you can’t measure them correctly with synthetics) will write - only then you will be able to understand how much you need resources.

Answer 2

It really depends on the optimization of the engine, you can process 10K connections on a cheap VDS, if you properly prepare the frontend and everything that can be cached. For starters, take a cloud from any hoster, you can increase the capacity until there is not enough, and then you will roughly understand what kind of hardware you need for the dedicator. What to optimize also depends on the engine, somewhere it is iops, somewhere the amount of RAM, somewhere the processor, somewhere the network, you need to look individually. And what, if not a secret, caused the choice of FreeBSD as an OS, the system is specific and requires deep tuning, but I don’t see, judging by the question, the relevant knowledge in you.

Answer 3

The question is very specific, because everything depends specifically on your application architecture and, no less important, on the correct choice of settings and system optimization. Specifically, recommendations: the use of VDS, VPS is very cost-effective. Most hosts will be able to provide you with the ability to scale capacity without any effort. With a lack of resources, you can simply climb over to a more powerful architecture. Also, many hosting providers ensure the reliability of data storage by means of backup (snapshots or space on the backup storage).
I can recommend ru.hetzner.com - a proven hosting and probably one of the most popular.
Do not forget that it is difficult for a home server to provide proper fault tolerance - power outages, problems with the Internet. As well as monthly additional costs for electricity and a wide stable Internet band.
On the issue of choosing an OS, it makes no sense to recommend something specifically. This is where the person below talks you out of FreeBSD. Reasons?

it’s just that everything works faster on Linux, it’s time
to administer and install 10 times easier, yes

One gets the impression that it's just that the hands are growing from the wrong place. With proper skill on any system, everything will work fine. I do not promote FreeBSD, I use Debian for such tasks. But the system is just a tool in the hands of a specialist, and the tools are chosen for a specific task. Therefore, choose the axis that best meets your requirements and is easier for the administrator to configure and optimize.

Answer 4

firstly, you should abandon fribsd,
it’s just that everything works faster on Linux, it’s time
to administer and set up 10 times easier, yes,
you just win a lot of money on this
alone, which is not clear to look at the speed of the ssd disk, it
seems to me with your childhood you will not be able to overload
it, which look at the RAM at its cost of 1000 rubles for 4 gigabytes
, take 4 bars of 4 gigabytes each and live happily
with proper optimization 1000 online users easily stretch on a Pentium 3 with 2 gigabytes of memory