3 ms·
So you downsized databases? I get that you can, to an extent, scale databases horizontally (especially if you don't need JOINs or you just use them for read ope
by arter4 3y ago
So you downsized databases? I get that you can, to an extent, scale databases horizontally (especially if you don't need JOINs or you just use them for read operations), but autoscaling databases sounds a bit risky
- sgarland 3y agoNot autoscaling; you just change the instance size. If you have a separate reader and writer instance you can do basically zero downtime by shifting everything to the primary, resizing the reader, then failing over and repeating. Or B/G if you don’t. Still very little downtime.
- arter4 3y agoInteresting. Where I work we just jumped from huge databases on prem to managed databases on AWS, so we totally skipped that step. Interestingly, we are now starting to experiment with smaller databases managed by us, so we may find ourselves in a similar situation.