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

Blackhawk-17 gravatar image

11.9k 28 31 37

(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

Aaron Alton gravatar image

Aaron Alton
575 2

Sounds reasonable enough. I was thinking from a scheduled maintenance point of view where,after bouncing all the physical nodes, all the vSQL instances are back where you want them. But if the nodes are roller-coasting on their own it could be a nightmare.
Oct 29, 2009 at 01:52 PM Blackhawk-17
(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: 1316 times

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