Need Help - Fail Over Servers Installation

[Parshwa]

Hello Everyone,

I need help in deciding what should I do to create a fail over server.

Server will host:

1. Web Server - Apache or Nginx
2. PHP Files - No changes in files. There is no need to sync files
3. MySQL - All data will be stored in a MySQL database. It will change overtime and needs to be synced.

Both servers will on a local network. If primary server fails, secondary server should take over automatically on same IP address.

When primary server comes back online, it should have latest data before taking over from secondary server.

What hardware configuration should I go for both servers?

 

[SirDice]

Handbook: 31.7. Link Aggregation and Failover

 

[Parshwa]

Handbook: 31.7. Link Aggregation and Failover

Thank you SirDice. What about syncing of MySQL data and what kind of hardware configuration should I go for?

 

[SirDice]

Hardware doesn't really matter much, you can have a proper failover with even the most basic hardware. As for MySQL you could use MySQL's own replication.

 

[Parshwa]

Hardware doesn't really matter much, you can have a proper failover with even the most basic hardware. As for MySQL you could use MySQL's own replication.

Thank you. I will go through that URL and try to implement it in few days. I will log everything and post it here. Thanks again.

 

[scottro]

There's also carp. https://www.freebsd.org/doc/handbook/carp.html

Probably because I learned it first, I find it easier as far as fallover if a machine died.


As an aside: If you want, you can test it in VirtualBox very easily, but be sure to enable promiscuous mode on the virtual machine interfaces.

 

[Parshwa]

There's also carp. https://www.freebsd.org/doc/handbook/carp.html

Probably because I learned it first, I find it easier as far as fallover if a machine died.


As an aside: If you want, you can test it in VirtualBox very easily, but be sure to enable promiscuous mode on the virtual machine interfaces.

Thank you. I will check Carp as well.