x

PolyServe Clusters

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

more ▼

asked Oct 23 '09 at 09:35 AM in Default

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

(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 '09 at 10:04 AM

Aaron Alton gravatar image

Aaron Alton
565 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 '09 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x19
x2

asked: Oct 23 '09 at 09:35 AM

Seen: 1138 times

Last Updated: Oct 26 '09 at 10:14 AM