You can’t build fault tolerant system without network lag. Your hardware can fail you any second, and every backup will be inconsistent with your local db. To solve it, you need to have a system with proper control plane and consensus algorithm like paxos inside.

SQLite is great for simple projects that can lose data, but, if you need to have no downtime, you need a distributed db.