Updating mysql server
For redundancy, 2 LANs should be used for the cluster to avoid a single point of failure and typically one would be reserved for the heartbeats between the cluster nodes.The My SQL binaries and data files are stored in the shared storage and Windows Failover Clustering ensures that at most one of the cluster nodes will access those files at any point in time (hence avoiding file corruptions).Once the wizard finishes, it starts up the My SQL Service.Click on the “Clustered My SQL” service branch to observe that the service is up and running.The installation is very straight-forward using the My SQL Windows Installer and selecting the default options is fine.
The wizard will then offer the shared disk that has not already been established as the quorum disk for use with the Clustered service – make sure that it is selected.
In the “Testing Options” select “Run all tests” and continue.
If the tests report any errors then these should be fixed before continuing.
This is a reasonable option to experiment with but probably not what you’d want to deploy with for a HA application.
If you already have shared storage set up then you can skip this step and use that instead.