Ill start by saying im new to debian... and a little bit more then a begginer with unix/linus OS.
I want to setup a failover between two identical systems running the exact same software. One would be my main server with the live information and have the other machine kick in if the first machine fails. The software I am installing is called Hotspot Engine. It installs the OS and all their required services out of the box. The software has an SQL, Apache, Radius server installed. I would like to setup both machines from scratch.. Setup the failover then begin to update all my information. then test to see if the failover is working.
I have looked around the web and found a few places talking about HA clusters using heartbeat but from what i found those dont work well with SQL...
Then i found a site saying just setup an rysnc script that will automatically run every 15 minutes and copies all the different files between the two systems
So My question is... What is my best option.. and How do i do it?! Does anyone have a step by step guide?
I only have the two servers and dont have an extra to monitor the two desktops ( i saw a few sites that required that)
Also if i wanted to set it up so both machines accept from the same internal IP address and that also fails over.
Any help would be GREATTTTLY APPRECIATED!