30 ms·
Evaluating high availability solutions for TimescaleDB and PostgreSQL
- ddorian43 8y agoAny solution that also has sharding (excluding citus that is single master) ?
- mfreed 8y agoHi @ddorian43, Timescale person here. I assume the question is asking more about TimescaleDB, rather than an HA solution that is shard-aware in is View management? We're in the process of building our own scale-out clustering solution, so that the many chunks that belong to a hypertable (some users have 10,000s of such chunks per hypertable) can be spread across many servers, rather than on a single primary as currently. ( Plan is to release this coming year; you can already see some PRs hit out public github about changes for this effect: https://github.com/timescale/timescaledb/pull/904 https://github.com/timescale/timescaledb/pull/904 )
- adamfeldman 8y agoI'm interested in solutions for pg HA that minimize data loss risk. Has anyone used Patroni's synchronous replication? How was your experience? In that vein, this looks important to maximizing safety in the event of split brain: https://github.com/zalando/patroni/blob/master/docs/watchdog.rst https://github.com/zalando/patroni/blob/master/docs/watchdog... Patroni synchronous mode docs: https://github.com/zalando/patroni/blob/master/docs/replication_modes.rst https://github.com/zalando/patroni/blob/master/docs/replicat...