←back to thread

264 points davidgomes | 6 comments | | HN request time: 0.785s | source | bottom
Show context
jgb1984 ◴[] No.41877172[source]
I've used postgresql in most of my previous jobs, but using mariadb in my current one, and I must say it's a joy to administer.

The replication and high availability that mariadb offers is rock solid, and much more advanced than what postgresql has to offer. It works out of the box, no plugins or third party shenanigans needed, and there is "one obvious way" to do it. Not a dozen options like in the postgresql ecosystem, each with it's own quirks and drawbacks.

Also, upgrades are a dream. I did 4 major long term stable release upgrades so far and everything was fully automatic and smooth sailing all around.

All of that with about 10 seconds downtime only for each upgrade, despite being a chunky 6TB database, thanks to the user friendly replication process.

I respect postgresql a lot, but mariadb allows me to sleep much better at night thanks to replication, smooth upgrades and no VACUUM to worry about.

replies(5): >>41877215 #>>41877287 #>>41877712 #>>41877884 #>>41878546 #
kstrauser ◴[] No.41877712[source]
To be fair to PostgreSQL, it has multiple replication setups because they have different inherent properties. For instance, it comes with built in streaming and logical replication setups. Which should you use? It’s impossible to say without knowing your own exact use case.

By analogy: should a database cluster optimize consistency or availability? Answer: there’s no way its author can guess which is more important to how you want to use it.

replies(2): >>41877950 #>>41878596 #
1. homebrewer ◴[] No.41877950[source]
MySQL/MariaDB have binary and logical replication too. They also support much more advanced topologies like multi-master out of the box. It's just that what you need for 99% of situations relies on a well trodden path and requires no configuration at all.

I have suspected for a long time that most people who criticize MySQL have never actually worked with it, or have done so a couple of decades ago. It's often the default choice if you don't need some of the PostgreSQL features (like PostGIS) and can work with either one.

replies(3): >>41878447 #>>41878603 #>>41879649 #
2. throw0101c ◴[] No.41878447[source]
> They also support much more advanced topologies like multi-master out of the box.

This is the one thing in My/MariaDB that I miss in Pg: Galera. So handy for in-house stuff that needs some kind of HA: either a three-server setup, or a two-server+arbitrator.

replies(2): >>41878580 #>>41878595 #
3. jskrablin ◴[] No.41878580[source]
Try https://pg-auto-failover.readthedocs.io/en/main/intro.html
4. mxey ◴[] No.41878595[source]
I haven’t used Galera, but I am very happy with https://patroni.readthedocs.io/en/latest/ for Postgres.
5. mxey ◴[] No.41878603[source]
MySQL has only logical replication, there is no equivalent to PostgreSQL‘s WAL/physical replication.
6. ttfkam ◴[] No.41879649[source]
Since v16, Postgres supports bidirectional logical replication out of the box. In other words, multiple writers.