I’m hung up on unrecognized charset #255. Tried rolling everything back to utfmb3; suppose I could go all the way to Latin1. I imagine there’s a lot of depth I could learn, but dropping mariadb for mysql seems like the path of least resistance right now.
eta: got the character set sorted. Had to make a new dump, confirm that everything in the dump was utf8mb3, then re-prime the replica with that data. Wasn’t enough just to change the character sets internally.
I’ve been trying to convince a VPS to run two instances of mariadb - one for local databases, one to replicate the homelab. Got mariadb@server and mariadb@replica sorted out through systemd, but now stuck on replication from mysql to mariadb. Looks like I’ll be ripping out mariadb and putting everything on mysql.
I’ve got all my internet infrastructure on one monitor - 50W for the N100, the cable modem, an ooma VOIP device, and UPS. I’d guess the server, with its WAP, 4x GbE ports, 2x spinning disks, and USB TV tuner, is 35-ish of those watts.
If you have the spare cash, I found the N100 NAS motherboard to be a great source of occasional weekend projects, and now it very definitely looks like I’ve gone overboard.
I started out just wanting a file server to store backups.then…
It didn’t feel like a lot, because it took years. Among the amazing things has been all the times I’ve been able to upgrade the motherboard by just plugging the HD into the new board. Started out just using old desktop boards; the N100 was the first purpose-bought board, and also the most complicated upgrade, because it added UEFI. There definitely are projects out there that don’t have an arm option, so something x86 is more flexible.
Pi 4 should be plenty to run Jellyfin, homeassistant, pihole and octoprint. Docker setup is pretty straightforward, and I can vouch that HA & pihole containers work great on RPi, if you want to leave the Jellyfin setup as-is and put the others alongside.
If you’re looking for an excuse to expand, my vote is for an N100 type system. I got one with 4 ethernet ports, PCIe for a wifi card, couple of NVME slots, and a half dozen SATA ports for $100-150. That’s a huge step up in potential without much increase in power draw. With the right wifi card, you can even use it to replace your WAP/router.
Yeah, I was going to say zip drives, or optical disks, but you really need to go back 20 years for them to be ubiquitous.
USB-A, maybe? Consumer 2.5" form disk drives?
Are you sure the ISP will delegate a /56? Mine supports prefix delegation, but will only give a /64, and it seems like subdividing that ¿into /72s? would be questionable.
Fetched it. Started it. Did a really nice job fetching my whole health record from insurance co & has a wide array of compatible providers. Decent presentation of repeated test results. It’s got a bunch of areas “not implemented yet,” but it’s a decent way to visualize the records. Probably even better if you have health records from multiple providers.
They do care that I wear clothes. Ain’t nobody’s day improved by seeing more of my skin.
IKR. An endless supply of real-world adjacent McGuffins, stored in secure locations, with justification for plenty of guards, and none of them are “nuclear codes,” “war plans,” or “drugs.” It’s a great way to keep doing familiar and popular game mechanics with novel narrative, just by picking a different cultural reference.
Safe deposit box is exactly the right size to hold a 3.5" HDD. Or several. I keep a backup Yubikey there too, because I love the physical token 2FA, but I’m pretty sure I’m going to lose it.
My faves:
https://app.electricitymaps.com/map/live/fifteen_minutes
https://map.purpleair.com/
Monthly (US) economic data from https://fred.stlouisfed.org/ including this particular graph: https://fred.stlouisfed.org/graph/?g=1CJfC
Came to say this. I recall especially the books private, paramilitary “marching clubs” being turned into law enforcement, which feels a lot like how the Proud Boys and 3% have fallen out of the media at the same time as ICE has co-opted their tactics.
“We’ll have fascism in [America], but we’ll call it anti-fascism” - Huey Long
The whole of US political commentary 1935-1939 feels very relevant today.
You don’t even need to learn HTML to do it. Any word processor will ‘save as HTML,’ but the markup should be straightforward enough for anyone considering selfhosting. CSS can be a real rabbit hole, but browser default styles aren’t awful.
Sounds like this is a good opportunity to learn something about yourself. It sounds like you don’t have any immediate needs for this windfall and it sounds like you don’t have strong desire to spend it frivolously. That’s good. Maybe you’re looking for an excuse to spend it frivolously. A lot of young people, given a big wad of cash, will rush out and spend it on some aspirational thing or experience - generally something that’s been all over media, or that their favorite influencers have raved about - then be left with the thing, which isn’t as cool after a few weeks or months as it seemed, or the memories. That pile of money came easy, left easy, so it doesn’t feel any different to be without it. That’s a trap known as the hedonic treadmill.
You can do this experiment on yourself: take some of that gift - enough to feel like “a lot” to you - and get yourself a nice bit of bling. Something you’ve had your eye on for a while, but never thought was realistic. Write down why you chose that thing and maybe a 1-10 scale of how much you think you’re going to enjoy it. Come back to that page in six months.
But I would definitely put most of it into some broad-market index/mutual fund, whatever’s available in Sweden. Making saving/investing part of your money habit early in life is a hell of a lot easier than trying to change bad habits later. And I don’t think your sis/BIL will offer you retirement the way they did your parents.
The short answer is: any amount of money is ‘worth’ investing.
$10k at 6% for 40 years is $100k. That might let you retire a couple years early. Conventional wisdom, among people, let’s say 40+ years old, is going to focus on retirement, wishing they’d started saving earlier, and the incredible power of 40 years compound interest.
At 19, though? You’ve probably got college and the potential for student debt coming up. Your first car. The down payment on a house. All of those things can be considered “investment,” too. They might have much better benefit to you, both in the short term and the long term. Or, if your BIL is ready to drop $15k as ‘pocket money,’ maybe you have enough family support that none of those things will be a concern. Hell, maybe you have enough family support that working a job from which to retire isn’t even a concern.
This is a marshmallow problem. Do you want to buy a car, take a fantastic trip somewhere, or just gamble like a big shot right now, or would you rather have less college debt, buy a nicer house, sooner, or retire earlier? Nobody else can tell you what you’ll enjoy more.
Honestly, as acts of appeasement go, a fancy dress party seems about the least humiliating thing a country can agree to. Play king for a day, like Make-A-Wish for senile fascists. If that settles the tariff negotiations, then well done.
I’ve used a retired desktop for my home server since 1999. It doesn’t have the fancy web-UI management of commercial NAS, but I’m comfortable with command line and config files.
At some point, I realized I could use its wifi card and hostapd to replace my WAP. That was a bit of an adventure initially finding a card that really supports AP mode and setting up hostapd, but has now allowed me to migrate from 802.11g to n to ac much cheaper than buying whole new devices,
Recently converted to an N100 with 4x ethernet ports, which let me unplug my little 5-port switch.
Managing this doesn’t feel like a second job: it’s stable and just works. Automatic updates, with kernel blacklisted; periodically log in, update kernel & reboot. It does give me the opportunity, when I get inspired, for a weekend project, like adding hostapd or a new service, either via docker or bare metal. I like that I have one device doing “NAS,” WAP, and router jobs.
Debt incurred by students divided by their post-graduation salary. For conventional medical school, it’s around 75%. Law school 35-40%. 688% is crazy.
I’m not a systemd guru, but it turned out pretty easy. https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html#systemd-multiple-mysql-instances Basically just make
[mysqld@copy]sections in my.cnf thensystemd start mysqld@copyand systemd is smart enough to passcopyinto mysql.I did it slightly different, using
systemctl edit mysql@.serviceto define different default files for each instance, then[mysqld@copy]sections in each of those files. Seems like theportoption for each has to go in a[mysqld]section, but otherwise ok.Replication because I want to put some live data, read-only, on the VPS, exposed to the world while the ‘real’ database stays safely hidden in my intranet. SSH tunnel so the replica can talk to the real database.