My backoffice components are doing MySQL queries. I need to ensure High Availability of MySQL (on Windows). I have a SAN available where I will store the DB file.
This is what I was thinking.
I will install 2 Windows machines with MySQL pointing to the shared db file. One will be active, the other one passive (MySQL service stopped). What I basically need, is a hearbeat between the 2 machines and when one is down the other one will actually start the MySQL Service.
Is this the right approach? If so, are there any product/open source out there that can help me set up this environment?
If I am using 2 different machine in such an active/passive mode -- how would my clients connect? Do they have to change their connection strings (basically the IP address/Machine Name) based on the currently active machine.