Ways to reduce the size that appwrite takes
Hi,
Forgive me for the strange question because I'm not an expert.
I have an appwrite selfhosted instance with 200 milion+ docs, the disk usage is 120+ gb
Is there a way to reduce the size of the db?
Are you sure that the DB is really using more than 120GB?
Docker stats are showing that?
Yes the docker volume is now at 120gb
The database volume?
Ok I'm gonna test this....
@jesus Also, you could try a different engine such as myrocks that has a better compression: https://mariadb.com/kb/en/about-myrocks-for-mariadb/
However the DB could behave differently and unstable
But you could try
Aso, @jesus Do you have document level permissions
No
@jesus Did it work? ๐
No ๐ญ
I just did this... created 1 tb cloud storage in vultr.
It's cheaper than upgrading the whole server.
You were not able to migrate? ๐
I see. What about Hetzner?
My account got blocked the next second it was created๐ contacted them, no answer, no explanation, nothing
Contabo is sh*t
Linode servers are not stable, i get abnormal crashes with them
You can't use a Gmail account I think
Weird. Never heard about it and they are not precisely cheap I think
They are cheaper than vultr on the cloud storage, and they offer up to 100tb on a single instance, vultr the max is 10tb
Interesting. I'm going to try Hetzner soon and move from Ionos. Hope they don't delete my production data or similar ๐
He failed fraud check
