Fail Over Server

trycatchthis

I have 2 nearly identical VPSes running some services.

I want a situation in which if VPS1 goes down traffic will go to VPS2 until VPS1 comes back up.
I do not need traffic to go to VPS2 unless VPS1 goes down.

Is there an easy guide to do this?

yoursunny

If they are Windows and in the same data center:
https://docs.microsoft.com/en-us/windows-server/networking/technologies/network-load-balancing

jcarlo9

Load balancer

TimboJones

Completely depends on the service and data.

Not enough information provided.

trycatchthis

@TimboJones said:
Completely depends on the service and data.

Not enough information provided.

Linux Nginx Apache Mysql Php on both VPS several websites on each
domain.com
vps1.domain.com
vps2.domain.com
DNS currently on both VPS but I am thinking I might need a 3rd party to handle the DNS.

TimboJones

@trycatchthis said:

@TimboJones said:
Completely depends on the service and data.

Not enough information provided.

Linux Nginx Apache Mysql Php on both VPS several websites on each
domain.com
vps1.domain.com
vps2.domain.com
DNS currently on both VPS but I am thinking I might need a 3rd party to handle the DNS.

What and how much changes in mysql?

If your service isn't critical to < 10 minutes downtime, forget all this. You'll pay more and take up more time learning with added complexity, etc.

Nice to have != need to have.

trycatchthis

@TimboJones said:
What and how much changes in mysql?

If I need to I will setup the master master replication in mysql, but at this point I could handle a bit of data inconsistency if the server is only down for a few mins to a day or so.

@TimboJones said:
If your service isn't critical to < 10 minutes downtime, forget all this. You'll pay more and take up more time learning with added complexity, etc.

I've got the motivation to learn.

TimboJones

@trycatchthis said:

@TimboJones said:
What and how much changes in mysql?

If I need to I will setup the master master replication in mysql, but at this point I could handle a bit of data inconsistency if the server is only down for a few mins to a day or so.

So how much time before you declare server 1 offline? How do you switch back to server1 after it comes back up? How do you resolve the inconsistency afterwards?

Sounds like you should setup mysql replication and just have both online all the time.

Tony40

@TimboJones said:

@trycatchthis said:

@TimboJones said:
What and how much changes in mysql?

If I need to I will setup the master master replication in mysql, but at this point I could handle a bit of data inconsistency if the server is only down for a few mins to a day or so.

So how much time before you declare server 1 offline? How do you switch back to server1 after it comes back up? How do you resolve the inconsistency afterwards?

Sounds like you should setup mysql replication and just have both online all the time.

I had read about MySQL live synchronization.

https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html

trycatchthis

@TimboJones said:
So how much time before you declare server 1 offline? How do you switch back to server1 after it comes back up? How do you resolve the inconsistency afterwards?

Hasn't something like this been done before and is like 20+ year old FOSS technology at this point. I just need to know where to look and all the details I will setup myself.