MySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL’s. I like Percona personally, but MariaDB is fine too.
Postgres with correct fillfactor, it doesn’t create new pages and works very fast.
Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn’t sound great.
Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.
MySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL’s. I like Percona personally, but MariaDB is fine too.
Is it true?
Postgres with correct fillfactor, it doesn’t create new pages and works very fast.
Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn’t sound great.
Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.