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 🎄🎁

  • Justin@lemmy.jlh.name
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    I’ve never used it, but I believe cockroachdb is also an option for multi-region replication.