0

Good morning all ,

I have an alwayson instance with a multisubnet listener

I configured RegisterAllProvidersIP = 0 in order to register a single DNS entry

HostRecordTTL is configured at 1200 seconds

I would like if with this configuration I will have timoeout during the failover

if so how much time is needed for the application to connect to the lsitener

thanks

1
  • You want the failover to timeout and fail after 20 minutes? Nov 28 '20 at 13:48
0

if so how much time is needed for the application to connect to the lsitener

Since you said HostRecordTTL is set to 1200 seconds, the application will take up to 20 minutes to reconnect after a failover that crosses subnets.

Ideally you should set RegisterAllProvidersIP = 1, and update your application's connection string to include MultiSubnetFailover = True. This will provide the best failover experience.

If your application uses a driver that doesn't support this setting, or you can't change the connection string for some other reason, and you need to reduce the failover timeout, then you'll need to lower the HostRecordTTL setting.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.