3 ms·

Of course there are a lot of benefits of using hosted databases. I like hosted databases and use them for both work and personal projects. What I have a proble

by c2h5oh 5y ago

Of course there are a lot of benefits of using hosted databases. I like hosted databases and use them for both work and personal projects. What I have a problem with is: - the premium over bare metal is just silly - maximum vertical scaling being a rather small fraction of what you could get with bare metal - when you pay for a hot standby you can't use it as a read only replica (true for AWS and GCP, idk about Azure and others)

viraptor 5y ago
> when you pay for a hot standby you can't use it as a read only replica (true for AWS I'm not sure what you mean here. At least for MySQL you can have an instance configured as replica + read-only and used for reads. Aurora makes that automatic / transparent too with a separate read endpoint.
- milesvp 5y ago
  A hot standby is not a read replica. It's a set of servers running in a different Availability zone mirroring current prod, that is configured to automatically fail over to if the primary is offline. It's been a few years since I personally set this up in AWS, but at the time, those servers were completely unavailable to me, and basically doubled the cost of my production servers. The fact that a hot standby is usually in some sort of read-replica state prior to failing over is a technical detail that AWS sort of tries to abstract away I think.
  - sciurus 5y ago
    They recently announced readable standby instances. https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/ https://aws.amazon.com/blogs/database/readable-standby-insta...
zerocrates 5y ago
Readable standby instances is something AWS just recently added actually: https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/ https://aws.amazon.com/blogs/database/readable-standby-insta... Though it seems to require you to have 3 instances rather than just letting you read from the standby... I don't quite get the rationale for that.
- bingo-bongo 5y ago
  Even though a hot standby is technically the exact same thing as a read only replica, it solves 2 very different problems (uptime vs scaling). Personally, I never want read only queries going to my hot standby, otherwise I risk the secondary can’t handle the load in case of failover. Probably a reason like that with AWS as well, as they are selling a “hot standby” product to ensure the uptime for your RDS.

by c2h5oh 5y ago

viraptor 5y ago

> when you pay for a hot standby you can't use it as a read only replica (true for AWS I'm not sure what you mean here. At least for MySQL you can have an instance configured as replica + read-only and used for reads. Aurora makes that automatic / transparent too with a separate read endpoint.

milesvp 5y ago
A hot standby is not a read replica. It's a set of servers running in a different Availability zone mirroring current prod, that is configured to automatically fail over to if the primary is offline. It's been a few years since I personally set this up in AWS, but at the time, those servers were completely unavailable to me, and basically doubled the cost of my production servers. The fact that a hot standby is usually in some sort of read-replica state prior to failing over is a technical detail that AWS sort of tries to abstract away I think.
- sciurus 5y ago
  They recently announced readable standby instances. https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/ https://aws.amazon.com/blogs/database/readable-standby-insta...

zerocrates 5y ago

Readable standby instances is something AWS just recently added actually: https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/ https://aws.amazon.com/blogs/database/readable-standby-insta... Though it seems to require you to have 3 instances rather than just letting you read from the standby... I don't quite get the rationale for that.

bingo-bongo 5y ago
Even though a hot standby is technically the exact same thing as a read only replica, it solves 2 very different problems (uptime vs scaling). Personally, I never want read only queries going to my hot standby, otherwise I risk the secondary can’t handle the load in case of failover. Probably a reason like that with AWS as well, as they are selling a “hot standby” product to ensure the uptime for your RDS.