this post was submitted on 17 Aug 2023
34 points (100.0% liked)

Selfhosted

60758 readers
204 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS
 

Faulty peripheral power supply killed my server a little over a day ago.
120 gigs of MySQL data just wouldn't come up - backup is far from recent. My fault. Most corrupted tables were of course in Friendica.
After much nail chewing everything now appears operational again with minimum(?) data loss.

In other words: can you all read me? ;-)

you are viewing a single comment's thread
view the rest of the comments
[โ€“] TCB13@lemmy.world 6 points 2 years ago* (last edited 2 years ago) (1 children)

Why so much? A simple daily timer that runs mysqlcheck + mysqldump + a backup of that would be enough for most people. Using a solid OS (Debian) and a filesystem such as BTRFS, ZFS or XFS will also save you from power loss related corruption. Why do people go SO overkill with everything?

Keep it simple, less services, less processes, less overhead, pick well written software and script the rest. Everything works out way better if you don't overcomplicate things.

[โ€“] pete@social.cyano.at 3 points 2 years ago

at least weekly mysqlcheck + mysqlddump and some form of periodic off-machine storing of that is something I'll surely take to heart after this lil' fiasco ;-) sound advice, thank you!