How to choose the right server for a large mysql database?

V

Vanya Huk2017-07-28 20:36:57

MySQL

Vanya Huk, 2017-07-28 20:36:57

How to choose the right server for a large mysql database, the database is about 70gb in size...

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

F

Fixid, 2017-07-28
@Fixid

Tell us about the specifics:
Expected RPS
Read/write, select/update/insert ratio
Expected growth per month
Degree of query optimality
Types of engines
Transactions
PS 70GB is not much

P

Puma Thailand, 2017-07-31
@opium

take an ssd and more memory
for the simplest databases, I usually take this config
https://www.hetzner.de/dedicated-rootserver/ex51-ssd
the system was in memory and the ssd disk was minimally twitching