I’m pretty new to the self hosting thing but I’m enjoying it a lot and want to go a bit further down the proverbial rabbit hole.

I’m looking at a bunch of services and they all require a DB, usually a MySQL DB. It seems counterintutitive to have 20 MySQL databases each in its own Docker container. So is there a way to have one DB across most of my services? (I realize that Nextcloud and other bigger items should have a dedicted DB.)

How would I set up a shared DB in a docker-compose file?

  • Ricaz@lemmy.world
    link
    fedilink
    English
    arrow-up
    5
    ·
    1 year ago

    I would just have Postgres running statically on some solid hardware. It’s easy to configure permissions and connections, too.

    Not too hard to set up streaming replication for a hot standby if you wanna be sure (or offload some reads).

    I use Postgres btw