Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Cluster always on

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <james.k.lowden AT icloud.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] SQL Cluster always on
  • Date: Thu, 07 Jan 2016 10:18:54 -0500

On Thu, 07 Jan 2016 10:31:46 +0100
"esterniclos AT gmail.com" <esterniclos AT gmail.com> wrote:

> Right now, TDS works as long as the listener is in the first node.
> In the example
> dblistener.myorg.com instance working in 10.57.3.2
>
> If the database is moved to another instance, it returns a
> timeout. Never checks the rest of IPs
>
> Possible solution
>
> Try to login in several times with as many objects as IP's are
> in DNS:
>
> tds/login.c:tds_set_host(TDSLOGIN * tds_login,
> const char *hostname)
>
>
> This would penalize a little when the database is in the
> backup instance, as it has to receive a timeout before making the
> connection.

Yours is a good idea. Don't worry about the delay introduced by timing
out on the primary, because the delay will normally be less than 1
second, provided DNS is working. A failed node will not accept a
connection on SQL Server's port if SQL Server isn't running.

$ time -p tsql -H www.freetds.org -p 8000
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
There was a problem connecting to the server
real 0.13
user 0.00
sys 0.00

It's very unusual for SQL Server to be running, accepting connections,
and timing out on logins. In any case, if the delay is important, the
configuration can be changed while the backup is in use.

HTH.

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page