Distribution of files loads the server. Decision?

Question

Nginx

There are VDS: 4 cores, 4 RAM, nginx.
There are files for 100-200 mb.
With active downloading, the server goes down. Bandwidth sags, MySQL crashes.


The obvious solution is to increase the performance of the server. And remove the direct link from the server...

But how to reduce the load on the server?
Limit download speed . I don't know a server level solution, advised this:

location /download {
    limit_rate 1000000;
    limit_rate_after 50000000;}

Yes, it limits the speed, but at the same time, the site becomes inaccessible for this user. And the speed is not fixed, it can sag significantly. On the chart, this is the penultimate plateau.

Installed a download manager for Wordpress . It also limits the speed, but the load on server resources has skyrocketed again (this is the last peak on the graphs).

Who will suggest an idea to solve this problem?

Answer 1

The obvious solution is to not serve files from the DB server. And in general, move it, if possible, to a separate infrastructure, not necessarily your own.