Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by otabdeveloper4 on Thursday May 11, 2023 @03:50PM
(#35907524)
Does Postgres have binlog replication yet?
[ Parent
| on HN ]
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by dijit on Thursday May 11, 2023 @03:52PM
(#35907552)
Yes, for over half a decade at least, but “binlog” is a MySQL term, for postgresql it has the much more apt name: write-ahead log.
it is the only official, in-binary replication mechanism.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by evanelias on Thursday May 11, 2023 @04:05PM
(#35907684)
Postgres WAL replication is a physical replication stream. MySQL binlog replication is a logical replication stream, a higher-level abstraction which is independent of the storage engines.
Postgres does separately support logical replication now, but it has some limitations, such as not permitting replication of DDL: https://www.postgresql.org/docs/current/logical-replication-...