3 ms·
Easier to scale application CPU usage horizontally than a single instance DB.
by winrid 3y ago
Easier to scale application CPU usage horizontally than a single instance DB.
- WJW 3y agoEven 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.