I am setting up two MySQL servers and I want to use one as primary server and the other as a secondary backup. I want to make sure both are synchronized and if one goes down, the other takes over as primary.
How should I set this up? What programs are available handle this? Do I need to setup MySQL replication?
Thank you for your suggestions.
Tony
How should I set this up? What programs are available handle this? Do I need to setup MySQL replication?
Thank you for your suggestions.
Tony