c2corg / c2corg/v6_api

Database read/write splitting or failover

Open
#567 1 comment 0 reactions 0 assignees View on GitHub
enhancement infra / prod
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.