3 ms·
SQLite itself does not have those features, but at the disk level you can get those features: On GCP: - A regionally replicated disk will replicate writes syn
by justsomeuser 6y ago
SQLite itself does not have those features, but at the disk level you can get those features:
On GCP:
- A regionally replicated disk will replicate writes synchronously to another zone (another data centre 100km away). This means when the SQLite write call returns, the data will be geographically replicated, and the second disk can be used as a fail over. This is all transparent to app/db.
- Disk snapshots are incremental, and are stored in Cloud Storage, which is geo replicated across regions (E.g. Europe and US).
In a way, this gets you even better failover and backups than traditional server DBMS's that have these features built in, and often need custom administration to ensure they are working.