What I'm trying to do is set up a failover system between two MS SQL Servers. It needs to be active/passive, and allow weighting (so Site 1 is preferable, before Site 2).
I've done this between our sites before, but on Linux, using Keepalived and HAProxy to use a VIP and proxy MySQL connections.
I'm looking for something similar that can run on Windows servers, and provide roughly the same functionality.
Bonuses would be to prevent flapping.
Application wise, we are using mostly ODBC connections stored on each server, so I could always do it from the application level. However, our subsystems can rely on each other, so we'd need everything to switch at once.
- Windows Server 2003
- MSSQL 2005
- Two machines
- On different sites, with a 10-20ms routed link between the subnets.