rails-sqlserver/activerecord-sqlserver-adapter — pull request #156 by ianic (2011-12-27 17:53:08+00:00)
Title: database mirroring support

Sql Server database mirroring support for dblib and odbc connections.

Mirror server could be specified in database.yml. In case of failed connection to primary server, adapter will try to connect to mirror.

Add :mirror section to your database.yml with mirror server specific connection params:

:adapter => 'sqlserver',
:mode => 'dblib',
:username => 'rails',
:password => '',
:database => 'activerecord_unittest_mirroring',
:dataserver => 'primary_server',
:mirror
:dataserver => 'mirror_sql_server'

For running test see ./MIRRORING_HOW_TO.md.