I have an architecture where my principal and mirror SQL on WLBS , and need to have synchronous mirroring with automatic failover , apps connects through WLBS VIPs, now if my DB failover happens how i can automate the WLBS to redirect requests to new node ? or any other solution ??
thanks