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
psupdateprocess or by stopping application services or the server itself whilepsupdateis 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
iddbqueues to subside.Stop the
iddbservice.If the cgi \ nodestat.exe (or its use as a REST endpoint) is used for load balancers to determine node availability, stopping
iddbis enough to stop incoming requests from the load balancer to that node. See also: Automated node check when using a load balancer .