fuser

joined 1 year ago
[–] fuser@quex.cc 1 points 1 year ago

Yes you understand the suggested approach. I don't know about the mariadb tool and if it looks good, by all means use it, but I would offer that the fastest, simplest way to restore a reasonably small database that I can think of is with a sql dump. Any additional complexity just seems like it's adding potential failure points. You don't want to be messing around with borg or any other tools to replay transactions when all you want to do is get your database rebuilt. Also, if you have an encrypted local copy of the dump, then restoring from borg is the last resort, because most of the time you'll just need the latest backup. I would bring the data local and back it up there if feasible. Then you only need a remote connection to grab the encrypted file and you'll always have a recent local copy if your server goes kaput. Borg will back it up incrementally.

[–] fuser@quex.cc 5 points 1 year ago (5 children)

for the database, consider a script that does a "mysqldump" of the entire database that you schedule to run on the system daily/weekly. Also consider using gpg to encrypt the plain text file and delete the original in the same script. This is so you don't leave a copy of the data unencrypted anywhere outside the database. You can then initiate either a copy of the encrypted file to a local folder that you're backing up, or if you've set this up to back up directly on the remote that's fine too - bringing it local gives you a staged copy outside the archive and not on the original host in case you need an immediately available backup of your database.

With respect to the 3 separate repos, I would say keep them separate unless you have a large amount of duplicated data. Borg does not deduplicate over different repos as far as I'm aware. The downside of using a single repo is that the repo is locked during backups and if you're running different scripts from each host, the lock files borg creates can become stale if the script doesn't complete and one day (probably the day you're trying to restore) you'll find that borg hasn't been backing your stuff up because a lock file is holding the backup archive open due to a failed backup that terminated due to an untimely reboot months ago. I don't recall now why this occurs and doesn't self-correct but do remember concluding that if deduplication isn't a major factor, it's easier and safer to keep the borg repos separate by host. Deduplication is the only reason to combine them as far as I can tell.

When it comes to backup scripts, try to keep everything foolproof and use checks where you can to make sure the script is seeing the expected data, completes successfully and so on. Setting up automatic backups isn't a trivial task, although maybe tools like rclone and borgmatic simplify it - I haven't used those, just borg command line and scp/gpg in shell scripts. Have fun!

[–] fuser@quex.cc 2 points 1 year ago

you have the main problem in hand. You'll still need to do all the DKIM / rDNS stuff to be certain your mail is accepted, but using SES as the source gives you a significant leg up vs originating locally. I don't see why you can't run dovecot and postfix on separate systems, but a single VM isn't bad if it's properly secured. Hosting SMTP/IMAP is not that difficult but you need to make sure you don't accidentally misconfigure things and become an open relay - as with all internet facing systems, mail services are targeted constantly so you should use fail2ban to deter them.

[–] fuser@quex.cc 3 points 1 year ago (2 children)

Link to low cost VPS hosting offers: https://quex.cc/post/29783

[–] fuser@quex.cc 12 points 1 year ago

this is just a quick script I came up with, but it will show you newest communities and their descriptions. It refreshes daily. maybe it will be helpful for discovering niche communities : https://lemmyfind.quex.cc/

[–] fuser@quex.cc 2 points 1 year ago

I don't know if it helps or not for me to point this out (I hope it's something that gives you some solace), but depending on the circumstances it's also very difficult to go through an investigation and trial. Maybe things are better now, but 20 or 30 years back it was an ordeal for the victim. The "what were you wearing?" mentality was very prevalent within the male-dominated judiciary and they made it so hard on the victims that they often felt like they were on trial - and in many cases they still didn't get justice either, despite their personal lives being dissected in front of a room full of strangers, some of whom were intent on falsely portraying them as promiscuous. After seeing this happen to a friend, I lost faith in the system to deliver justice. I don't have a solution, but an adversarial system just doesn't seem ideal for this kind of prosecution.

[–] fuser@quex.cc 1 points 1 year ago* (last edited 1 year ago)

The best part is watching these idiots blow their fortunes thinking they are going to continue building on the old paradigm of monolithic platforms when the ground is gradually shifting towards diversification via decentralization and they are behind the curve now, not in front of it. This is not your dad's internet. Hopefully they continue splashing out huge amounts of cash in ill-fated efforts to prove they are still relevant. There's no fool like an old fool - and old, rich technically-out-of-touch fools who lack the self-awareness to stop imagining they are hip are particularly amusing.

[–] fuser@quex.cc 3 points 1 year ago (1 children)

everyone has their price. with unlimited funds he should be able to make something pretty slick for whatever the vision is - not that I would ever use it, of course. But don't imagine that software engineers won't compromise their politics if the money is good. Given the necessity of income, you can rationalize anything if you really need to.

[–] fuser@quex.cc 1 points 1 year ago

It exists to provide the illusion of competition.

[–] fuser@quex.cc 39 points 1 year ago* (last edited 1 year ago) (12 children)

it's not an assumption at this point. They are just a pair of losers who got lucky. They are the best argument imaginable for restoration of a 90% tax rate and inheritance taxes.

[–] fuser@quex.cc 1 points 1 year ago (1 children)

yes, there had to be catch, although the guy in this letsencrypt support thread is a senior Letsencrypt engineer and he seems to be saying it is possible - although letsencrypt doesn't support it. I do think you'd have to show a bit more to the issuer to prove ownership than an http acme challenge though.

view more: ‹ prev next ›