I wrote the application that uses a MySQL server. But we didn't want to have the users have to configure the client software. In my code I search for the server at start up as well as during the run if the connection is lost the search is done again.
There was no failover implemented at the server level.
I want to configure Virtual IP(VIP) for given below scenario
Server A (Windows/Solaris)
Server B (Windows/Solaris)
Both server on same network.
I want to configure VIP for application failover. Our application is running on server A, a standby instance will be placed on ServerB. If ServerA is unavailable Server B will start listening /processing requests.This failover will be transparent to users mean users will connect to same IP as they connect to ServerA. e.g user/device connect to ServerA with IP 192.168.254.11 when ServerA is down ServerB start accepting requests for IP192.168.254.11
Kindly tell me how can I do that?