Time for some more DB space!
-
Time for some more DB space!
Our #CosocialCa Mastodon instance has been steadily growing as it fills up with posts from our members and the broader #Fediverse, and we're getting near the limit of our DB cluster at Digital Ocean.
I'm gonna push some buttons and embiggen our cluster shortly.
If DO does things correctly, no one will notice.
Because I am a responsible (paranoid) sysadmin, I am taking a backup right now and will proceed when it is done.
-
Seems like itβs still workingβ¦
-
It worked as intended! Bring us your posts!
-
@mick at what point will you decide to delete some shit?
-
Joseph Szymborski :qcca:replied to Mick π¨π¦ last edited by [email protected]
@mick super cool, out of curiosity, do we use DO's managed db? I was thinking of maybe using it for a future project. The main attraction being that there are daily automated backups (and the easy scale-up, obvi)
-
@pl Insofar as thereβs value in the shit that weβre keeping, weβll keep it.
Weβre not running any relays at the moment, so the posts weβre pulling in from elsewhere are all intended to be here based on member behaviour.
Old posts add more useful content to our search index, so Iβm in favour of keeping them.
There are more economical ways to run this thing. Iβm inclined to explore these options first, rather than dump old posts.
-
Mick π¨π¦replied to Joseph Szymborski :qcca: last edited by
@jszym Yes, weβre using their managed PostgreSQL.
Itβs expensive (relatively speaking) but you get a lot of value for the expense. Not having to worry about maintaining replication and push-button scaling saves a lot of administration burden.
-
@mick interesting that there's a setting to delete what I write but none to delete what I've read
-
@pl Posts that end up in the instance because of your follows belong to all of us now. οΈ
There are some administrator tools that allow for purging of posts older than X days if they haven't been interacted with by anyone on the server.
This is probably worth investigating at some point, but it wasn't going to save us enough space this time around to avoid having to increase the DB soon enough (from 60 GB to 80 GB.)
When it gets to 120 GB we might purge instead of trying to keep up.
-
Erin Dalzell (He/Him)replied to Mick π¨π¦ last edited by
@mick brb uploading 34679758 GB movie, thanks for the space!
-
Mick π¨π¦replied to Erin Dalzell (He/Him) last edited by
@emd bring it on!