Hello everyone !
I have a node app and a PostgreSQL DB in VPS using Docker, with Coolify as a CI/CD, nothing too fancy, you might say.

My question is the following.
I have a lot of read/write on my DB and even the lowest increase in DB latency can have an impact on my users’ experience. As my VPS is in France, what could be the best/easiest (selfhosted?) option to solve this problem in other regions (North America, Asia…) ?

Thks in advance 🎄🎁

  • aksdb@feddit.de
    link
    fedilink
    English
    arrow-up
    0
    ·
    11 months ago

    You might want to check out CockroachDB, which is to a big degree compatible with PostgreSQL (even on driver/protocol level) but is specifically designed for geo replication.