I am looking to set up a MySQL backup server in case I ever have one go down. Is there away for each server to mirror each other or a way to cluster them together to provide a redundant back up system?
I would be interested to hear what others have done.
Thanks
-Jarrod Lash