Comment on Stop using MySQL in 2026, it is not true open source
roguelazer@lemmy.world 6 days agoMySQL 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.
msage@programming.dev 5 days ago
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.