Multigres v0.1 Alpha: an operating system for Postgres

Summary

Multigres v0.1 alpha is an open-source release of a system intended to provide Vitess-grade horizontal scaling, high availability, and operational simplicity for Postgres. It manages Postgres instances with sharding, connection pooling, automatic failover, and backup orchestration, while this release adds advanced pooling, automatic failovers, and a Kubernetes operator. Its high-availability protocol builds on unmodified Postgres replication, supports user-defined durability policies, resolves split-brain scenarios without losing succeeded commits, and permits replica changes while running. The release is suitable for experimentation but not production workloads: v0.1 is single-shard, sharding is absent, the custom-resource API may change, backward compatibility is not guaranteed, and performance benchmarks are still in progress.

Takeaways

1. 1

   The HA protocol supports user-defined durability policies, including cross-zone durability, instead of requiring a fixed majority-quorum rule.

2. 2

   The connection pooler tracks request state, pins stateful requests when necessary, maintains separate per-user pools, and consolidates prepared statements across gateways.

3. 3

   The alpha is a single-shard release; sharding is not included, the CR API is unstable, future releases may not be backward compatible, and performance benchmarks are pending.