3 ms·
Even easier (and much less error prone when it comes to ACID properties) would be to scale the single instance DB vertically instead.
by WJW 3y ago
Even easier (and much less error prone when it comes to ACID properties) would be to scale the single instance DB vertically instead.
- winrid 3y agowell, no. This is because there's a cap (albeit very high these days) scaling vertically - but the bigger advantage is you can also variably scale the application. It's a much bigger pain to scale up and down your DB instance with traffic. application pods can just be shut down etc. Also you can just wrap your queries in a session/transaction on the client, so no worries there. But yes, don't do this until you need to.