Re:Ask HN: How do you backup your database?
by yawgmoth on Wednesday February 01, 2023 @08:35AM
(#34610159)
Debezium is a change data capture tool that can replicate changes to another target, such as a backup.
A common pattern with Postgres databases is to replicate the WAL to a read replica. If the primary goes down you promote the replica to master. I have to imagine there is a similar recipe for MariaDB.
Re:Ask HN: How do you backup your database?
by janxgeist on Thursday February 02, 2023 @03:21AM
(#34623736)
I actually did set up replication to another database, several years ago.
But at the time, for some reason the databases would de-sync to easily (often when changing the db scheme).
A common pattern with Postgres databases is to replicate the WAL to a read replica. If the primary goes down you promote the replica to master. I have to imagine there is a similar recipe for MariaDB.