Re:MariaDB ditches products and staff in restructure
by Spivak on Sunday October 15, 2023 @02:23PM
(#37892066)
MySQL can actually do one better which is semisync. The transactions get replicated synchronously but applying them is async. You can't lose data anymore due to a primary failure.
[ Parent
| on HN ]
Re:MariaDB ditches products and staff in restructure
by jvdongen on Sunday October 15, 2023 @04:43PM
(#37893238)
Postgres has a similar feature, if you chose ‘remote_write’ for the ‘synchronous_commit’ setting.
You can also mix and match sync/ascync options within a cluster and even between individual transactions.
Recent versions of Postgres have a really flexible replication configuration to cover a whole range of requirements. See e.g. https://www.postgresql.org/docs/current/warm-standby.html#SY...