Failover clustering and mysql

[Gelato]

Does anyone know how to make use of the Windows 2008 Server Failover Clustering with MySQL? I've heard about it and am looking to use it, but wanted to learn more before I bit the bullet.

[Rocky]

Originally Posted by Gelato

Does anyone know how to make use of the Windows 2008 Server Failover Clustering with MySQL? I've heard about it and am looking to use it, but wanted to learn more before I bit the bullet.

Hi,

Currently MySQL DB clustering works perfectly in Linux but the Windows part of this is in Beta & according to the MySQL 5.1 manual, "MySQL Cluster is not currently supported on Microsoft Windows. We are working to make Cluster available on all operating systems supported by MySQL, including Windows, and will update the information provided here as this work continues."

For a shared disk failover solution on Windows you will be looking to implement the Windows Cluster Service. Please see: Implementing Windows Cluster Service

The explanation here is general and should be able to be applied to MySQL fail-over.