The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.


Is it possible to keep a database running while adding/de-commissioning a node from Microsoft/Veritas Cluster?

The idea is to have zero downtime during HA setup/maintenance


asked 03 Jul '13, 10:27

Lincoln%20Tang's gravatar image

Lincoln Tang
accept rate: 0%

edited 03 Jul '13, 11:20

Mark%20Culp's gravatar image

Mark Culp

Yes, this is possible. If you are running SQL Anywhere in a cluster and it is configured (in the cluster management software) to failover, you have it running on one node while you perform maintenance on other nodes in the cluster.
Note that to function in a cluster, the database server must be in a resource group with the shared disk (where the database should be placed) and the public facing ip address of the cluster. This will guarantee that if any of those resources fails over to another node, they will all go together.

permanent link

answered 03 Jul '13, 11:21

Jason%20Hinsperger's gravatar image

Jason Hinspe...
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 03 Jul '13, 10:27

question was seen: 681 times

last updated: 03 Jul '13, 11:21