Earlier quoted context omitted.
The "making it catch up" is the tricky part. You need an initial backup for that. xtrabackup can take that backup "hot" without blocking read/writes. mysqldumper will block writes for whatever time that initial backup takes, for 2TB of data that's going to be hours. Once you have that initial back up you can set your replica and make it catch up , then you switch. I choose to take the few seconds of downtime doing th…
Isn't that just a flag? "--lock-tables=false", alternatively --single-transaction for InnoDB.
Migrating from DigitalOcean to Hetzner
281–290 of 454 posts
Re: Migrating from DigitalOcean to Hetzner
#282What's the HA plan? Sounds like from the requirement to live migrate you can't really afford planned downtime, so why are you risking unplanned downtime?
Re: Migrating from DigitalOcean to Hetzner
#283Earlier quoted context omitted.
That’s like saying Mercedes is a scam because you’re fine with a Honda Civic. It’s a totally legitimate preference but not being in the target market doesn’t make something a scam.
AWS ain't no Mercedes. Mercedes feels premium and isn't full of bugs. AWS and Azure a charging an arm and a leg, but the offered quality is mostly perceived. Most of the bits and bobs they charge for are not providing much value for a vast majority of businesses. I won't even go over the complete lack of ergonomics with their portals.
Maaan, I have some bad news for you...
Re: Migrating from DigitalOcean to Hetzner
#284A few months ago, I looked into AWS alternatives for my small SaaS side project. My main motivations were to save money and maybe support some EU cloud providers. At first, I planned to go with Hetzner and accepted that I would need to do a lot of things myself. However, the dealbreaker for me was that Hetzner IPs have a bad reputation. At work, I learned that one of the managed AWS firewall rules blocks many (maybe…
Re: Migrating from DigitalOcean to Hetzner
#285A few months ago, I looked into AWS alternatives for my small SaaS side project. My main motivations were to save money and maybe support some EU cloud providers. At first, I planned to go with Hetzner and accepted that I would need to do a lot of things myself. However, the dealbreaker for me was that Hetzner IPs have a bad reputation. At work, I learned that one of the managed AWS firewall rules blocks many (maybe…
Re: Migrating from DigitalOcean to Hetzner
#286Over the years I've heard plenty of horror stories from Hetzner customers.
Re: Migrating from DigitalOcean to Hetzner
#287Earlier quoted context omitted.
> Surely you must've noticed that pretty much all of their bare metal offerings ("dedicated" and the stuff on "auction") have multiple disks, allowing for various RAID configurations? I don't know where to start with this comment. Do I really need to spell out the difference between cloud and bare metal ? A few examples... - Live migration ? Cloud only. - Snapshots ? Cloud only. - Want to increase disk space ? Tick b…
Well you did say your data is lost when a disk fails, which is not true. Parent pointed out that for you. Yeah you pay for and get additional stuff with cloud. Nobody disputed that.
Well, technically its still a possibility.
I am old enough to have seen issues with RAID1 setups not being able to restore redundancy, as well as RAID controller failures and software RAID failures.
Also, frankly you are being somewhat pedantic. My broader point was regarding cloud. I gave HD Failure as one example, randomly selected by my brain ... I could have equally randomly chosen any of the other items ... but this time, my brain chose HD.
Re: Migrating from DigitalOcean to Hetzner
#288Re: Migrating from DigitalOcean to Hetzner
#289Every time I see this kind of article, no one really bothers about sb/server redundancy, load balancers, etc. are we ok with just 1 big server that may fail and bring several services down? You saved a lot of money but you'll spend a lot of time in maintenance and future headaches.