Before database maintenance starts
Before the database maintenance starts:
Ensure no bulk processes, including scheduled ones like auto discovery , are running on the application nodes that update that specific database.
Warning
Do not interrupt the auto discovery process either by manually stopping the
psupdate
process or by stopping application services or the server itself whilepsupdate
is running.Interrupting auto discovery may leave behind broken queues or other data which may lead to data loss and lost access to the application by a large percentage of its users.
If you need to run server or application database maintenance, plan for it and disable the PSUPDATE scheduled job ahead of time.
That includes any other Custom automated means of running the process, or any other bulk automation.
Remove the application nodes using that database from the load balancer.
Wait for outgoing
iddb
queues to subside.Stop the
iddb
service.If the cgi \ nodestat.exe (or its use as a REST endpoint) is used for load balancers to determine node availability, stopping
iddb
is enough to stop incoming requests from the load balancer to that node. See also: Automated node check when using a load balancer .