3 ms·
PostgreSQL is nowhere near Clustering / HA / sharding features. Afaik it's only a master / slave architecture by default.
by Thaxll 11y ago
PostgreSQL is nowhere near Clustering / HA / sharding features. Afaik it's only a master / slave architecture by default.
- jpgvm 11y agoSure, but the underlying primitives are better. Specifically it supports quite flexible binary replication including the new logical replication features. With this you can build things like Manatee[1] which enable effectively seamless HA. The platform I am currently working on Flynn[2] uses a variant of this state machine to implement an effectively maintenance free Postgres cluster. In future though there will be support for bi-directional replication in Postgres, i.e true multi-master support. [1] https://github.com/joyent/manatee https://github.com/joyent/manatee [2] https://flynn.io/ https://flynn.io/