PolyServe Clusters

When defining your virtual SQL servers and monitors in PolyServe why would you NOT use AUTOFAILBACK?

more ▼

asked Oct 23, 2009 at 09:35 AM in Default

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I don't have any experience with PolyServe per se, but generally speaking automatically failing back isn't usally desirable in any cluster. Normally you would want to investigate the cause of the failover and correct any issues that need addressing prior to scheduling a time to fail back.

Again, I don't know about PolyServe, but with Windows Server Failover Clustering (or MSCS), a failover requires starting up the instance (running recovery, etc) - while the downtime is minimal, it still necessitates downtime.

In the worst case, if your original active node still has an issue and you're employing autofailback you can end up bouncing an instance back and forth between your two nodes - meaning that your HA solution isn't providing very much availability at all.

more ▼

answered Oct 27, 2009 at 10:04 AM

avatar image

Aaron Alton
575 2 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 23, 2009 at 09:35 AM

Seen: 1486 times

Last Updated: Oct 26, 2009 at 10:14 AM

Copyright 2018 Redgate Software. Privacy Policy