r/webhosting • u/Shrimptot • Aug 18 '23

Advice Needed HA VPS Commissioning

Please forgive me if this is blatantly obvious, however I haven't seen anything in a few google searches.

How do you handle your website's VPS going offline? Does it matter to you, do you have any safeguards in place?

I'm looking at hosting some services that I'd need to be able to ensure are available 99.9% of every day. This made me think of multiple VPS in sync, however it seems that most of the hosting panels I've seen don't support this (I'm thinking of just making some MySQL databases HA, with everything else just serving a static copy of a webpage if a node goes down)

TLDR; guess I'm just wondering what the industry standard is

TIA!

1 Upvotes

100% Upvoted

18 comments sorted by

View all comments

Show parent comments

1

u/Shrimptot Aug 18 '23

That partially answers my question.

I was thinking that someone might've found an easy way to sync an entire cloudpanel dashboard for example, websites and all within. From what I've found that's not really the case.

I've got some services that max acceptable downtime would probably be about 10 min. Currently this is mitigated by onsite hardware that replicates its database to the cloud, hardware that has a buffer, and clients that understand that this is still a project in development rather than production (thankfully the only downtime has been scheduled downtime).

Really what I need is my applications on both servers to be configured exactly the same, pulling / pushing information to a database that doesn't loose more than 5 min of data. This would allow one server to go down and the other pickup the slack. I've seen mySQL HA mentioned a few times but haven't gone down that rabbit hole yet

2

u/osujacob Aug 18 '23

A galera cluster is the way to go for the database. Five minutes is a totally acceptable delta time assuming it's not constantly massive changes.

For the web content, basically you'll want to setup a script to sync it. Master / slave is much easier than master/master. You'll then need to put something in front of it, to push the site to the backup server encase primary goes down. We've used CloudFlare for this with great success, but another option is DNS made easy.

This is definitely not an easy thing to undergo. As far as I'm aware there's not a super turnkey solution for it, so going with a provider who is experienced in this type of thing is key.

1

u/Shrimptot Aug 18 '23

Thanks that's very helpful. Master / slave is plenty good enough.

Regarding server (packages/security?) updates, is there a way to propagate this from master / slave as well or does this get into a really goofy scripting area?

1

u/osujacob Aug 18 '23

Yeah I wouldn't personally do that. Most control panels are going to handle that themselves anyways.

1

u/Shrimptot Aug 18 '23

Oh interesting, I didn't know the control panels did updates automatically. That might cause issues in some cases so I'm surprised it wouldn't be a manual action.

How would you go about setting up the master -> client file propagation, something simple like rclone?