3 ms·

I certainly could. Yes I am on SSD. But then moving to a bigger server is essentially just delaying the problem I am going to have to solve sometime in future.

by iKSv2 8y ago

I certainly could. Yes I am on SSD. But then moving to a bigger server is essentially just delaying the problem I am going to have to solve sometime in future. Also right now I can afford some time window of bad (slow) performance while I essentially migrate.

bufferoverflow 8y ago
Have you thought of installing slave DB servers to spread the reads? Have you looked into why your slow queries are slow? Seems like indexes are missing, or your queries are unoptimized.
JimmyAustin 8y ago
You'd be surprised how far you can push the problem into the future. OVH will sell you a server with 512GB of RAM for under a K a month. You can easily go into the terabytes.
- bufferoverflow 8y ago
  Hetzner PX92 with 256GB DDR4 is just $219/month.
brudgers 8y ago
Curious about your staff's past experience with database migrations.
- iKSv2 8y ago
  This makes me uncomfortable. Even though we have done some migrations (albeit of lower scale). Please share pointers, if any.
  - deleted 8y ago
    [deleted]
  - brudgers 8y ago
    Your comment says most of what is worth considering.
    - iKSv2 8y ago
      Gotcha