3 ms·
We use mysql in prod at work and frankly the reason I didn't bother bringing up the mysql vs postgresql debate is simply high availability. We have a multi-mas
by znpy 5y ago
We use mysql in prod at work and frankly the reason I didn't bother bringing up the mysql vs postgresql debate is simply high availability.
We have a multi-master mysql database based on percona's pxc.
And it works beautifully... sometimes a node crashes and it's no big deal.
Meanwhile in pgland it's quite a landmine of solutions, each of which seems to be studied accurately. And there is a constellation of other solutions (extensions or posygresql distributions) that maybe fit your use case, maube don't.
- ttfkam 5y agoPerhaps you should check out YugabyteDB https://www.yugabyte.com/ https://www.yugabyte.com/ or CockroachDB https://www.cockroachlabs.com/ https://www.cockroachlabs.com/
- znpy 5y agoI'll be honest, CockroachDB looks fishy. https://www.cockroachlabs.com/docs/stable/learn-cockroachdb-sql.html CockroachDB SQL? Isn't it supposed to be 100% PostgreSQL compatible? https://www.cockroachlabs.com/pricing/ CockroachDB Core - Open-source with foundational features. Uff... Let's go give a look at the licenses: https://github.com/cockroachdb/cockroach/blob/master/LICENSE https://github.com/cockroachdb/cockroach/blob/master/LICENSE So many licenses, including the Business Source License which is non-free license. Also there's this CockroachDB Community License (CCL), which I guess is a made-up license that's going to include some whatever terms. I might still accept this mix of licenses however I can't find the definition of "foundational features" -- what do I "lose" by using the OSS version instead of one of their managed offerings? From a quick overview, it's soft-no from me (in the sense that it probably wouldn't be my first choice).