• carrylex@lemmy.world
    link
    fedilink
    English
    arrow-up
    23
    arrow-down
    1
    ·
    edit-2
    4 hours ago

    Ok so if I’m reading this correctly: They migrated from an OS and MySQL version receiving no updates since at least 2 years to MySQL 8.0 which will stop getting updates in 4 days. Also every service is running without any containerization and there is a single database for everything… and it all runs on a single host and I didn’t read one word about a backup strategy or disk encryption. Also not a single word about infrastructure as code like ansible so that you can reliably recreate the system… and The whole stuff is hosted in Germany for a Turkish software company - sounds like very good latency.

    My personal conclusion: This system WILL fail and the guy who designed it is stuck somewhere 10-20 years in the past.

    • Passerby6497@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      ·
      43 minutes ago

      every service is running without any containerization and there is a single database for everything… and it all runs on a single host and I didn’t read one word about a backup strategy or disk encryption.

      Man, a paragraph that can give someone some serious PTSD flashbacks…

      The number of times I’ve had to clean up a customer’s environment after they let little Billy play corporate IT and things went boom…

    • xthexder@l.sw0.com
      link
      fedilink
      English
      arrow-up
      1
      ·
      edit-2
      1 hour ago

      Sounds like my homelab has better redundancy than these guys, and my monthly bill isn’t much different than their new one. I only pay for power and networking, since I own my own hardware. I’m colocating in my city, so my latency to home is about 1ms, and I’ve got a full mirrored server in my house. Certain files are further backed up elsewhere for proper 3-2-1 backup (+ each server running raidz2 with disk encryption). Even if my home Internet goes out, I still have full access to my files at home, and all my public services stay running in the data center. If either server fails, it’s all set up with containers so it’s easy to spin up each service somewhere else.

      One thing that’s tricky to get right with disk encryption (especially with encrypted /boot) is having a redundant boot partition. I was able to hack this together by having sofware raid duplicate my boot partition to a second drive. Now if I remove either OS boot drive it falls back to the remaining one. To prevent breaking EFI boot, you need to use the Version 1 RAID format so the metadata is stored at the end of the partition, not the front where EFI reads.

  • Wispy2891@lemmy.world
    link
    fedilink
    English
    arrow-up
    14
    ·
    6 hours ago

    Not a sysadmin but just an hobbyist: is it ok to have such a large install bare metal and not containerized?

    For example the issue of MySQL 5 being unavailable would be a non-issue with a container

    • raspberriesareyummy@lemmy.world
      link
      fedilink
      English
      arrow-up
      3
      ·
      2 hours ago

      For example the issue of MySQL 5 being unavailable would be a non-issue with a container

      So people careless enough to “just container it” for old, possibly security-compromised software - you call that a “non-issue”? How about upgrading and configuring for compatibility?

    • Encrypt-Keeper@lemmy.world
      link
      fedilink
      English
      arrow-up
      3
      ·
      edit-2
      2 hours ago

      Yes it’s ok, in general. It’s not the most modern or efficient way of managing infrastructure but it’s worked for decades now. It all depends on what you’re hosting, for who, and for how many people.

      If you’re hosting internal company infrastructure for a relatively static number of users in a single of set few regions to deliver to, bare metal monolithic stuff is absolutely fine. It’s when you’re an app or service company and your infrastructure is for the back end for a public service that needs to be able to scale dynamically, and you’re worried about high 24/7 uptime, and latency to end users is a global issue that things like microservice architecture, containerization, and iac starts becoming important.

      The whole containerization crazy is important for microservices architecture where you split your app into different pieces. This lets you scale different parts of you app as needed, it prevents your entire app from failing just because one part of it failed, it allows for lifecycle management like blue/green deployments with no downtime, allows developers to work on different parts of the app and update at a faster cadence than one big release for the entire thing every time you update one small part of it, things like that.

    • recursivethinking@lemmy.world
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 hours ago

      you can just set up containers on your bare metal server. in fact if you’re going to install insecure services you definitely want to containerize them, though tbh you need to run really far away from whatever it is you’re doing that requires sql5, or at least don’t let it be reachable on the internet, that should be network-isolated, which really limits its utility.

      • Passerby6497@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        38 minutes ago

        in fact if you’re going to install insecure services you definitely want to containerize them,

        While this is true, if you’re running a platform that is root by default (looking at you, docker), you’re not shielding yourself as much as you might think you are.

        If you’re running an insecure app as root, you better hope they don’t also have an exploit to get out of the container after the app is popped, otherwise you’re fucked.

    • inzen@lemmy.world
      link
      fedilink
      English
      arrow-up
      3
      ·
      5 hours ago

      Don’t quote me, but as far as I know containers can’t fix the issue if the host kernel is too old.

    • just_another_person@lemmy.world
      link
      fedilink
      English
      arrow-up
      3
      arrow-down
      5
      ·
      5 hours ago

      Wha?

      You do realize there are plenty of bare metal infrastructure deployments out in the world, yeah? Being in a container solves no problems in this scenario at all.

  • zr0@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    8
    arrow-down
    1
    ·
    7 hours ago

    Wait until you learn that Hetzner can and will take your public IP away at their own will without any warning. Happened to me.

    One downtime is enough for me to never use that service again, no matter how cheap it is.

      • zr0@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        7
        ·
        3 hours ago

        Copy Paste since I am lazy:

        “ They suspected me of serving “illegal” traffic. The server was located in Germany and they were contacted by typical DMCA lawyers, who were referencing a US District Court Order.

        Hetzner blindly waved that through and just took my public IPv4 address.

        At no point they were trying to contact me. At no point they asked themselves if a US District Court Order has any validity. At no point anyone of Hetzner explained what happened. At no point they apologized for their obvious mistake.”

      • zr0@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        2
        ·
        3 hours ago

        They suspected me of serving “illegal” traffic. The server was located in Germany and they were contacted by typical DMCA lawyers, who were referencing a US District Court Order.

        Hetzner blindly waved that through and just took my public IPv4 address.

        At no point they were trying to contact me. At no point they asked themselves if a US District Court Order has any validity. At no point anyone of Hetzner explained what happened. At no point they apologized for their obvious mistake.

    • Dyskolos@lemmy.zip
      link
      fedilink
      English
      arrow-up
      28
      ·
      8 hours ago

      0? My energy company says I’m using power equivalent to a family of eight. And it’s just wifey , the servers and me. I had cops here asking if I grow weed 😁

      So unless you steal power, it surely isn’t close to 0 😁

      • notthebees@reddthat.com
        link
        fedilink
        English
        arrow-up
        2
        ·
        4 hours ago

        This is why im doing my homelab on low powered processors (5825u NAS boards). Runs way cooler and is way more efficient. Same performance as my 9900kf gaming PC cpu wise.

      • wltr@discuss.tchncs.de
        link
        fedilink
        English
        arrow-up
        14
        ·
        8 hours ago

        I realised I don’t need my servers being online 24/7, so for me that’s Raspberry Pi and equivalents, plus powering on computers on demand.

        • greybeard@feddit.online
          link
          fedilink
          English
          arrow-up
          9
          ·
          6 hours ago

          A trick I realized a few years ago: Caddy has a module you can build it with that does WOL. So I was able to run a Caddy reverse proxy that woke up my higher powered server on demand, and let it go back to sleep when I wasn’t using it. Might be a bad idea for a database sever, but for my uses it was pretty simple and effective.

        • Dyskolos@lemmy.zip
          link
          fedilink
          English
          arrow-up
          4
          ·
          8 hours ago

          Oh. Okay. That comes close to 0. Mine runs 24/7, just because it would take too long to power down and up all machines, VMS, switches etc 😁

          • wltr@discuss.tchncs.de
            link
            fedilink
            English
            arrow-up
            5
            ·
            8 hours ago

            More likely your system is more sophisticated, I have just joined the hobby, so to say. But I am sure you can go much cheaper than that with bare metal. If I’d really need to host something, I’d rather buy a real server, and invest in solar power instead of paying some rent. Was a happy Digital Ocean customer, before I realised I can do the same with a Raspberry Pi. I was buying a couple of Pis a year for them. Right now, de-facto one Pi can host everything I really need. I regret I wasted about half a thousand on nothing. Could have bought a great NUC instead of wasting money on the cheapest VM for years.

            • Regrettable_incident@lemmy.world
              link
              fedilink
              English
              arrow-up
              4
              ·
              8 hours ago

              Yeah solar power is much more affordable these days. I live in a vehicle so I have a 500w panel on the roof charging a 200ah lithium battery. I only use a laptop and steam deck, but could easily upscale. The whole system, including the victron controllers & shunt and the 2k inverter came out around £700, but I’m pretty sure stuff has only got cheaper since I bought it. I have way more power than I need in summer, though there are maybe two months in winter when I have to charge everything in daylight. I could always add a small wind generator if I needed. Renewables are totally feasible these days

      • SeductiveTortoise@piefed.social
        link
        fedilink
        English
        arrow-up
        2
        ·
        5 hours ago

        I think I’m at a family of four or five, but I’m alone with my dogs and my weed and my servers. Being able to legally self-host your own drug supply is great.

      • gusgalarnyk@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        6 hours ago

        How does running a server, assuming it’s used some amount of internet bandwidth, handle residential internet speeds? If I’ve got a gig up and down, can I reasonably run like a jellyfin for my friends?

        • xthexder@l.sw0.com
          link
          fedilink
          English
          arrow-up
          1
          ·
          1 hour ago

          Most servers you rent are only going to have 1Gbps internet speeds too unless you’re paying extra, so if you’ve got symmetrical gigabit at home, you’re 100% good to go, except for maybe higher downtime than a datacenter. My fiber at home seems to go out for a bit overnight occasionally as they’re doing maintenance.

        • Tywèle@piefed.social
          link
          fedilink
          English
          arrow-up
          4
          ·
          6 hours ago

          If I’ve got a gig up and down, can I reasonably run like a jellyfin for my friends?

          Easily

    • Armand1@lemmy.world
      link
      fedilink
      English
      arrow-up
      14
      ·
      9 hours ago

      I also self host and I wouldn’t say the cost is zero. In the UK, energy costs alone mean that a 40W computer cost £8 per month to run (assuming a 28p/kWh price).

      Of course, that’s assuming you run it 24/7 at full energy use, but I know my PCs run on more than that.

      • kalpol@lemmy.ca
        link
        fedilink
        English
        arrow-up
        1
        ·
        5 hours ago

        28p per kWh? Holy smokes.I think it ranges from 5 cents to 8 cents per kWh here. There are a lot of fees tacked on but those are there anyway.

        • Armand1@lemmy.world
          link
          fedilink
          English
          arrow-up
          1
          ·
          4 hours ago

          Yeah just went to check and the price in my area is 22-28p/kWh, can confirm.

          It’s very fucked over here.

          • Gonzako@lemmy.world
            link
            fedilink
            English
            arrow-up
            1
            ·
            7 hours ago

            You might wanna do the math on solars, even if its a cloudy place like the UK, their lifespan and nearly 0 upkeep makes them great value

            • grue@lemmy.world
              link
              fedilink
              English
              arrow-up
              1
              ·
              2 hours ago

              How’s the math work on a shady place? I’ve got a big-ass tree above most of my roof.

            • Armand1@lemmy.world
              link
              fedilink
              English
              arrow-up
              1
              ·
              6 hours ago

              I don’t own a house yet, like most people in the UK under 40, but when I do I will definitely consider it.

  • SMillerNL@piefed.social
    link
    fedilink
    English
    arrow-up
    16
    ·
    10 hours ago

    Seems like it would have been a good moment to split the database from the many web servers and reduce the single point of failure.

    • phutatorius@lemmy.zip
      link
      fedilink
      English
      arrow-up
      10
      ·
      10 hours ago

      And get some replication in there. Even if there’s not a single point of failure, if a DB instance ever goes tits-up, you’d better have a standby.

      Source: I’ve cleaned up others’ messes where they didn’t.

  • uuj8za@piefed.social
    link
    fedilink
    English
    arrow-up
    36
    ·
    12 hours ago

    I’m in the US and when I tried migrating from DO to Hetzner, I got asked to upload my passport to prove I’m not spam or something. Same experience with OVH.

    Is this a thing for all European hosting companies? I ended up finding some Canadian hosting that would just let me sign up and pay like normal.

    • doeknius_gloek@discuss.tchncs.de
      link
      fedilink
      English
      arrow-up
      15
      ·
      9 hours ago

      When I signed up at Hetzner, I had to go through the same anti-abuse check. However I could choose to not upload my ID and pre-pay 20€ instead. Did that and have been a happy customer since.

    • rjek@feddit.uk
      link
      fedilink
      English
      arrow-up
      19
      ·
      11 hours ago

      Lots of respectable EU hosting companies, and also aparently OVH, if they think there’s a chance you’re taking the piss will ask for a ID so they can ban you. It’s not just anti-spam, it’s anti-abuse and for preventing non-payment. They think there was a risk involved in accepting your business (whatever that may be, obviously companies don’t dilvulge their criteria here), and if you go elsewhere they’re not upset about it for that reason.

      • melroy@kbin.melroy.org
        link
        fedilink
        arrow-up
        3
        arrow-down
        1
        ·
        8 hours ago

        Good. I’m sick of all those ddos attack and bot attacks from other cloud provides like alibaba etc.

    • luokaton@lemmy.zip
      link
      fedilink
      English
      arrow-up
      17
      ·
      12 hours ago

      I never had that kind of experience with Hetzner or OVH as a European. I suppose there are extra hoops to jump through for US customers for some reason?

        • melroy@kbin.melroy.org
          link
          fedilink
          arrow-up
          6
          arrow-down
          1
          ·
          8 hours ago

          I don’t like uploading IDs. But recently I block almost all datacenters across the world due to ddos attack or other malicious attacks on my websites. So I don’t think it’s a bad idea to keep the web better. It’s a mess today due to all those cheap cloud providers

    • A_norny_mousse@piefed.zip
      link
      fedilink
      English
      arrow-up
      5
      ·
      11 hours ago

      Is this a thing for all European hosting companies?

      Absolutely not. At least not in Europe.

      Have you tried netcup as well?

      • devfuuu@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        4 hours ago

        Netcup was the one I had most problems years ago about uploading identify check. Last year when I signed again they actually put a system in place that it’s simpler, you just show your face for some photos and show your identity card and it checks if it matches. So an external identity provider. Simpler than having to see how to upload copies by email with pgp (which they support and have documentation about).

        • A_norny_mousse@piefed.zip
          link
          fedilink
          English
          arrow-up
          1
          ·
          2 hours ago

          It’s so weird. Where from? I never had any such requirements with any provider, even when I, from Europe, bought something from abroad.

      • uuj8za@piefed.social
        link
        fedilink
        English
        arrow-up
        3
        ·
        10 hours ago

        Let’s see! 🤞

        Your order will be checked by one of our employees shortly. You will then receive further information on the status of your order by e-mail.

  • wltr@discuss.tchncs.de
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    1
    ·
    edit-2
    8 hours ago

    I love how they censored the title on the orange site, you have no price in it.