What server is needed?

Question

Database

Hello. There is an online store. About 4 million positions are withdrawn from suppliers. Goods unfortunately without descriptions, characteristics and photos. It is possible to obtain this data from suppliers. Since there are many positions, there is even more data. It is necessary to store this data somewhere and process it somehow.
While thinking about buying an old server, put it in the office, so that when accessing the product card, this server processes the necessary data and gives it back.
Unfortunately, I don't understand server hardware at all.
What server do I need? How to choose the right server for my purposes?

Answer 1

First you need to decide on the amount of data, in what format you will store it, what do you mean by processing, and how fast it should give.

Answer 2

big
I would take from 32 gigs of RAM
, you can try small and then increase, if you don’t figure it out, welcome to our private hosting

Answer 3

Sometimes a regular PC is installed and used as a server, the reliability is lower than that of professional hardware and the speed, but everything works fine. It also depends on the channel, if the traffic of a large office channel may not be enough. Better rent a server, any where there is enough disk, google VPS, VDS for 500-1500 per month will be normal for a start

Answer 4

From the beginning, you need to look at ur. memory costs, downloads, etc .. and then think.
Your words mean nothing.
And so percent. xeon the most dead with 4 cores will go.
4-8gb ram.
ssd in raid + hdd in raid too.
Should be enough. What will you have 4 mil. goods, it does not mean anything, it all depends on how many requests per second, connections.

Answer 5

I would advise you not to invest in a full-fledged server.
First, it is not economically viable.
You will need to pay for electricity, for Internet channels (reservation) for a piece of iron. All of this comes at a good price.
Get yourself a VPS with average characteristics and payment of 1000 rubles per month.
Hosting will take responsibility for fault tolerance and channel redundancy.
12 thousand per year, cheaper than 50-100 thousand per server + internet fee + electricity.
As long as you have all this at the development and promotion stage, you will not get a lot of traffic. Therefore, in the first six months - a year, VPS will save you.
When you realize that your site has started to gain momentum and your server is not coping, you will have 2 solutions.
1. Put VPS more expensive.
2. Buy your own server.
In terms of software, I would advise you to choose a more serious solution for such database volumes. For example, pay attention to PostgreSQL, if you have specified a 50GB database volume.
If the database is small, then install MySQL, everything can always be migrated to more serious solutions.

Answer 6

ovh.ie/dedicated_servers/HG - BHG-2 server. Performance guaranteed.

Answer 7

Firstly, immediately dismiss "put in the office", the problems with the availability of such a database will be very big, you need a very good ping from the face to the base, and if you are also going to store photos in the database ...
Secondly, VPS? what other VPS, when you need at least 8-16 gigs of RAM just to raise the indexes from your positions into memory, otherwise you will just beat IO, which the VPS does not have, these are fairy tales.
As a result, you need a regular server, but the cheapest one.
https://www.hetzner.de/ot/hosting/produkte_rootser...
Here is the minimum config, 32 giga + will actually give you not i7, but xenon, hetzner does not have i7 in stock now.
Need an SSD? +10 euros per month https://www.hetzner.de/ot/hosting/produkte_rootser...
Need it cheaper? see salehttps://serverboerse.de/en/index.php?country=OTHER

Answer 8

Putting a server in your office is a pretty stupid idea. There will be constant problems with food and the Internet channel. It will be much more profitable and reliable to rent a dedicated server. If you have a new store with a small attendance, an ordinary VDS with a tariff like this is enough for your eyes: VDS Fly Away (4 cores, 4096 MB, 120 GB) like this,