Mysql Failover

I have one master server Mysql and one slave working with replication feature and works really fine!

I can install another slave, but the question is how can I do a transparent automatic failover MySQL server scenario... (Both servers are connected by VPN)

Regards
lnriveraAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jeremycrussellConnect With a Mentor Commented:
If you have Windows Server and MSCS available, you can install a MySQL HA cluster using the generic service resource.  Not sure if this is something available to you or not though.  However, it would provide you with the automated failover you are looking for.

You can implement a failover scenario with you master/slave setup...  However, it would not be instantaneous and would require intervention (although it could be automated).  You would have to promote the slave to a master, etc.. etc..  A pretty touch undertaking compared to the alternative.
0
 
jeremycrussellCommented:
To do transparent failover of MySQL, your best bet would be to institure an HA cluster of MySQL.  You're slaves act as your data redundancy, but do not provide true High Availability capabilities for the MySQL service.
0
 
lnriveraAuthor Commented:
The cluster is for MySQL or OS cluster?
0
 
lnriveraAuthor Commented:
I need to do it in Windows
0
 
jeremycrussellCommented:
It would be an OS  based cluster.   What OS are you running?
0
All Courses

From novice to tech pro — start learning today.