FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Beth Woods wrote:
> 
> Our servers are mirrored so that if 
> the primary goes down the mirror will automatically handle any new
> connections.   How can I configure this with the freetds driver?  What I
> basically need is an  alternate server.  I did not see that as an option
> for the configuration file.  

Welcome to the project, Beth.  

FreeTDS doesn't do any kind of failover.  It follows DNS.  In my work
environment, we have a CNAME DNS record that points to the primary.  On
failure, that entry is changed to point to the secondary.  

I think this kind of arrangement is fairly common.  

HTH.  

--jkl