Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server 2005 Mirroring

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Beth Woods <agentbeckett186 AT yahoo.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server 2005 Mirroring
  • Date: Tue, 17 Apr 2007 04:17:55 -0700 (PDT)

Thank you for the quick reply. That was very helpful, even though it wasn't
the answer I was hoping for :)

Thanks,
Beth

----- Original Message ----
From: James K. Lowden <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Sent: Monday, April 16, 2007 10:31:59 PM
Subject: Re: [freetds] SQL Server 2005 Mirroring

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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com




Archive powered by MHonArc 2.6.24.

Top of Page