MySQL Server build help

[1llusion]

Hello!

 

I have been working on a project recently involving storing large amounts of data into a MySQL database. Usually, I run my projects on an old computer, but it seems to not be able to handle the database and the code at the same time anymore so I've been thinking about investing in a server focused only on the database side of things.

 

As I am a student, I need to keep to cost down as much as possible, what would be your recommendation? I've looked at several refurbished servers, but I have no idea what to be looking out for.

I'm from the UK, so I'm looking at the UK and EU stores.

 

What parts should I focus on? Which brands are preferred as well as which CPU and how much ram would you recommend?

Thank you for your help!

[Electronics Wizardy]

How big is your database? You want this in ram if you want it fast. Id go with something like a dell r720 or or 710 as there is cheap ram, and you can get 128gb+ for a few hundred. You probably also want ssds.

[1llusion]

3 hours ago, Electronics Wizardy said:

How big is your database? You want this in ram if you want it fast. Id go with something like a dell r720 or or 710 as there is cheap ram, and you can get 128gb+ for a few hundred. You probably also want ssds.

Right now it's quite small with 132mb at 1,2 mil records. But I'll be adding around a million records a day so I expect it to grow quite large quite fast. Thanks for the suggestion!

 

EDIT: Just found locally someone selling a server, what do you think of these specs?

Model: R710 3.5" 6 Bay 

CPU: X5650 x 2, 2.66GHz, Six core CPU

Memory: 48GB of RAM - PC3 10600R

Power: 2 x Redundant 870W PSU 

[Jarsky]

Should be good. Ideally you want enough ram that the database can be cached in memory to avoid disk swapping.

To avoid having to buy stacks and stacks of ram, thats why it's good to run SSD's as the seek time on them is only a fraction of that of mechanical hard disks.

 

Also if you enable the general_log, again its a good idea to have SSD's for their throughput speed. 

It's typically a good idea to have the general_log enabled with a file output, for troubleshooting purposes. 

 

[1llusion]

6 hours ago, Jarsky said:

Should be good. Ideally you want enough ram that the database can be cached in memory to avoid disk swapping.

To avoid having to buy stacks and stacks of ram, thats why it's good to run SSD's as the seek time on them is only a fraction of that of mechanical hard disks.

 

Also if you enable the general_log, again its a good idea to have SSD's for their throughput speed. 

It's typically a good idea to have the general_log enabled with a file output, for troubleshooting purposes. 

 

Thank you for your help!