this post was submitted on 09 Jun 2023
7 points (100.0% liked)

Sysadmin

7542 readers
1 users here now

A community dedicated to the profession of IT Systems Administration

No generic Lemmy issue posts please! Posts about Lemmy belong in one of these communities:
!lemmy@lemmy.ml
!lemmyworld@lemmy.world
!lemmy_support@lemmy.ml
!support@lemmy.world

founded 1 year ago
MODERATORS
 

My job has been Database Admin for the past 25 years, still is. But nowadays it's more shifting to infrastructure and automation.

And of course I do some self-hosting.. like lemmy.world and mastodon.world and many others..

Thank you @DarraignTheSane@lemmy.world for creating this community!

top 17 comments
sorted by: hot top controversial new old
[–] MrPoopyButthole@lemmy.world 1 points 1 year ago (1 children)

Systems and software engineer here. I'm curious how the Lemmy project plans on scaling media uploads. It doesn't seem feasible to host on an instance server. Even Reddit had a problem with media over the years and some subs to this day enforce offloading media to third party.

[–] ruud@lemmy.world 0 points 1 year ago (1 children)

For now it's 2GB. I hope we can use block storage soon. I use Wasabi for mastodon.world

[–] huojtkeg@lemmy.world 0 points 1 year ago (1 children)

Just Postgres or Postgres + Pics? Could you give me the number for Postgres? I'm thinking in hosting my server but I have concerns abot scalability and costs in the future.

[–] ruud@lemmy.world 0 points 1 year ago (1 children)
du -sm *
2181	pictrs
1885	postgres
[–] huojtkeg@lemmy.world 0 points 1 year ago (1 children)

It seems a lot for little content. My experience tells me that Postgres is not going to scale well, some sort of NoSQL will be necessary.

[–] ruud@lemmy.world 0 points 1 year ago (1 children)

Why not? My mastodon DB is 200 GB, works fine.

[–] huojtkeg@lemmy.world 1 points 1 year ago* (last edited 1 year ago) (1 children)

It depends on many things like the number of tables, the indexes, etc... but Postgres doesn't work well above 1 TB. Anyway, it will take several years to reach that point. Someone will figure out a solution.

Thank you for the info. Do you have any link with the specs of your server, bandwidth, cpu/ram usage, statistics...? Anything that could help me to do the maths.

[–] ruud@lemmy.world 1 points 1 year ago (1 children)
[–] pcr3@lemmy.world 0 points 1 year ago (1 children)

I'm curious, how have the numbers changed in the last few weeks?

[–] ruud@lemmy.world 1 points 1 year ago (1 children)

Well we use a new server now, with 32 core/64 threads and 128GB RAM. So quite some more..

[–] pcr3@lemmy.world 1 points 1 year ago

haha that's awesome! keep up the good work.

[–] OmarDontScare@lemmy.world 1 points 1 year ago* (last edited 1 year ago) (1 children)

Hey @ruud@lemmy.world, fellow SysAdmin here! Thank you for hosting this Lemmy instance! It's a great place, uptime has been excellent!

I've a question, if you're willing to give your opinion. Hardware is not cheap and eventually it might become impossible to pay the bills to host this instance.

What kind of support model do you envision for the future of this instance? Donations, subscription, advertisements?

Thanks anyway, and good luck to you!

Edit: I see that donations are already optional. Nice! But i'm still curious, so is there other options you've considered for your Mastadon instance for example?

[–] ruud@lemmy.world 3 points 1 year ago (1 children)

Hi, I think donations will be the way also in the future. Anything non voluntary wouldn't work because people will just move to other servers that are free. And so far I've seen there's more than enough willingness to donate.

[–] OmarDontScare@lemmy.world 1 points 1 year ago

Great to hear that there is a lot of people willing to donate! I agree with your argument regarding free servers, curious to see what other instances will be doing.

Thanks for getting back to me. Have a great day! :)

[–] ArtVandelay@lemmy.world 1 points 1 year ago

Data Scientist here, thanks for the instance! Loving it so far.

[–] DarraignTheSane@lemmy.world 0 points 1 year ago (1 children)

Hey @ruud@lemmy.world , thanks for chiming in here on /c/Sysadmin! I've been trying to figure out how to best manage the Sysadmin communities I've setup across different Lemmy servers, but it's looking like lemmy.world might be my new home server since it appears to have the best uptime and stability. 😉

[–] ruud@lemmy.world 1 points 1 year ago

Thank you! If you have multiple Sysadmin communities, maybe it's an idea to close all of them but 1. Just mark them as 'only moderator can post' and pin a post telling people to subscribe to the 1 community.