4 ms·
First make sure you can't solve your problem by moving to a more powerful server. 145GB is tiny. 256GB of DDR3 is less than $600 on eBay, and can fit your whole
by bufferoverflow 8y ago
First make sure you can't solve your problem by moving to a more powerful server. 145GB is tiny. 256GB of DDR3 is less than $600 on eBay, and can fit your whole DB.
Also, are you on a SSD?
- iKSv2 8y agoI 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 agoHave 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 agoYou'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 agoHetzner PX92 with 256GB DDR4 is just $219/month.
- brudgers 8y agoCurious about your staff's past experience with database migrations.
- hiram112 8y ago> 256GB of DDR3 is less than $600 on eBay... Wow - I see PC builders paying $150+ for 16GB. I guess ram really goes down in price once you start buying in bulk / server memory.
- s_esser 8y agoDDR4 are the kind those PC builders are buying