4 ms·
Yes, there are a number of great options here provided out-of-box: 1. All plans (including the lowest-cost dev tier) includes PITR recovery out of the box. Yo
by mfreed 6y ago
Yes, there are a number of great options here provided out-of-box:
1. All plans (including the lowest-cost dev tier) includes PITR recovery out of the box. You can also "fork" any current database to a second instance (e.g., for dev & test), also at any recent point-in-time.
2. Once you create any instance, you can later create a "read replica" with one click, which creates an asynchronous replica of your primary (e.g., for ad-hoc queries to not interfere with the primary, or to just load-balance reads).
3. On the HA side, our "pro" plans includes automatic synchronous replication between primary/replica, so that any primary crashes failover without downtime to the replica. You also get DNS-named endpoints for replicas, again for load balancing reads.
- GordonS 6y agoOn the Basic tier, I presume you have to pay for those read-only replicas? Can they be used for automatic failover, or only for scaling reads? I don't know what VM SKUs you use on Azure, but at a glance it looks like your solution would cost 300-400% the cost of the VM, just for your Basic tier. As a fan of TimescaleDB, I really want to like this, but I'm just not seeing enough value-add for the price. Maybe I'm missing something, please sell me on the benefits over managing VMs myself?