Make regular backups of the DB.
tbh that should apply to any kind of selfhosted service, especially when its not only for you
Comment on How "heavy" is self-hosting matrix really?
LodeMike@lemmy.today 2 days ago
It can baloon as it scales up. Matrix.org (homeserver) has had at least one DB corruption and that’s with their proprietary Rust bindings for Synapse. Small communities, especially ones that share rooms between them, should be fine on most systems. Make regular backups of the DB.
WhyJiffie@sh.itjust.works 20 hours ago
LodeMike@lemmy.today 2 days ago
There’s also issues with the state disagreement / resolution algorithms across federation.
Has this been solved? Maybe it’s also due to database corruption, where some state is forgotten across the federation, and thus the algorithm breaks down?
northernlights@lemmy.today 2 days ago
And, importantly, run the db on postgre, not sqlite, and implement the regular db maintenance steps explained in the wiki. I’ve been running mine like that in a small VM for about 6 months, i join large communities, run whatsapp, gmessages and discord bridges, and my DB is 400MB.
screenshot of cloudbeaver