For MariaDB you can implement logical master-master replication between 2 servers (or a Galera cluster if you have 3 or more servers).

I have done this for my servers with MariaDB (master-master logical replication) and apart from some very rare hiccups it works very well. You can do the same for PostgreSQL.

For SQLlite there are some solutions like Litestream.

At the moment I am on MariaDB but my plan is to migrate to PostgreSQL.