Hi

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

Thanks

asked 03 Jul '13, 10:27

Lincoln%20Tang's gravatar image

Lincoln Tang
66338
accept rate: 0%

edited 03 Jul '13, 11:20

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


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...
2.7k63447
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×61
×4

question asked: 03 Jul '13, 10:27

question was seen: 1,529 times

last updated: 03 Jul '13, 11:21