4 ms·
I reconsidered mysql after switching jobs and seeing a multi-master clustered mysql database. Is anything similar available for postgresql?
by znpy 6y ago
I reconsidered mysql after switching jobs and seeing a multi-master clustered mysql database.
Is anything similar available for postgresql?
- why-el 6y agoNothing in core, but there are products that have good online karma (at least I haven't read horror stories, the lack of which is always good news). See https://en.wikipedia.org/wiki/Multi-master_replication#PostgreSQL https://en.wikipedia.org/wiki/Multi-master_replication#Postg... for some examples.
- rpedela 6y agoIf your data has an obvious shard key, like customer ID, then I suggest taking a look at Citus. Not exactly multi-master, but a good sharded solution for PG. There is a managed version of Citus on Azure too.