MySQL service binded with virtual IP

[sujith deva]

Hi

I would like to go for a fail over MySQL services with two servers.

Here all the data directories are in SAN partition and the common SAN partition will be available on both the Mysql instances in between servers.

Our aims is to make redhat cluster between the two servers.

When the master server will fail the IP will swap to the secondary server and MySQl server should start in the second server.

Only when the server got the Virtual IP the MySQL servic should run on the server.

So im looking for the configuration where we can bind the IP with the MySQL service for this fail over.

Thanks

Sujia