Database read/write splitting or failover
- Dominant language
- Python
- Stars
- 26
- Forks
- 28
- Avg merge
- 4h
- Merged PRs (30d)
- 9
Description
Currently postgresql is a SPOF. We can't reconfigure/resize/move/update it without putting the whole website offline for at least a few seconds.
We'd need either one of these:
- having sqlalchemy sending write requests to a different DB connection than read requests.
- having sqlalchemy being able to failover to a second (read-only) database in case the first one goes away.
In both cases, the app needs to be clever enough to gracefully handle the case where the (single) writeable database is gone. A sort of maintenance mode where everything is read-only, and the feedback to the user is unambiguous about it.
When discussing this with @tsauerwein this afternoon, he mentioned: https://github.com/camptocamp/c2cgeoportal/pull/2223
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.