cancel
Showing results for 
Search instead for 
Did you mean: 

Zero downtime for HA setup/maintenance

Former Member
0 Kudos
1,761

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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.

Answers (0)