Database is resetting?

[hilmia]

Hi!

I'm hosting my Novu deployment on a Digitalocean droplet without decoupling the database.
Is it in that case normal that the database gets reseted? It happened a couple times now, had to register and create the workflows again. I'm not very familiar with how the Docker containers work.

Will this be solved if I decouple the database and host it in a managed database in Digitalocean?

Thanks!

[michaldziuba03]

hello @hilmia

Do you use docker-compose from deployment folder, right? Because development compose has volume for mongo set in tmp folder, where data can be dropped when server is restarted.

Trying to answer the question - I think yes, decoupling database should solve the problem. But database shouldn't reset, I think there is persistence problem with droplet or docker. Novu deployment docker compose uses named volumes to persist data,

What are the circumstances when the database resets? It happens when you reset droplet or "by itself"?

[michaldziuba03]

@hilmia You can inspect volume (it always should be named deployment_mongodb). Remember "CreatedAt" date and if you find that database data is gone again, inspect volume again and if "CreatedAt" will be different, then I would suspect some misconfiguration on Droplet side as it drops volume.

If "CreatedAt" will be same, then something is wrong with Docker or our docker-compose.yml config.

$ docker volume ls

local     foobar
local     xyz
local     deployment_mongodb
...

$ docker volume inspect deployment_mongodb

[
    {
        "CreatedAt": "2023-07-10T10:05:02+02:00",
        "Driver": "local",
        "Labels": {
            "com.docker.compose.project": "deployment",
            "com.docker.compose.version": "2.17.3",
            "com.docker.compose.volume": "mongodb"
        },
        "Mountpoint": "/var/lib/docker/volumes/deployment_mongodb/_data",
        "Name": "deployment_mongodb",
        "Options": null,
        "Scope": "local"
    }
]

[hilmia]

Thank you. I created a separate managed db in Digitalocean and connected Novu, and all is good now.