I have a LAMP server with a lot of hardware redundancy built in. I am not worried about the server becoming unavailable. What I am worried about, however, are potential network issues in the data center the server is in. What I would like to have is another server in another data center for redundancy. Load balancing is less of a concern.
With that said, I am relatively clueless on two points:
- How to have two servers in two geographically separate data centers that have exactly the same data, in terms of both files and MySQL databases.
- How to ensure that all traffic coming into one data center are automatically transferred to the other database in the case of a network or server failure at the first data center.
Any guidance on how to accomplish the above two problems would be greatly appreciated.