I am currently looking into viable options for creating a much better network setup (HA) for my apache/mysql servers.
The configuration i am looking into is two Apache servers and two MySql servers running behind a load balancer
I am just a bit confused on the best methods for keeping both the MySql databases and the Apache servers in sync with each other. I would need both databases to be identical all the time as well as the Apache servers.
For the Apache servers I was considering setting up a Git server to control the versions on each servers as well as pushing updates to each server but I am not sure if this would be the best method.
Any suggestions or help would be greatly appreciated.