7.4

Table Of Contents
Scenario: Perform a Maintenance Database Failover
As a vRealize Automation system administrator, you must perform an appliance database maintenance
failover operation.
This scenario assumes that the current master node is up and running normally. There are two database
failover maintenance steps: maintenance of the master and maintenance of a replica node. When a
master node has been replaced so that it becomes a replica, you should perform maintenance on it so
that it is suitable to become the master again should the need arise.
Note Do not stop or restart the HAProxy service on the applicable host machine while performing a
maintenance failover.
Prerequisites
n
vRealize Automation is installed and configured according to appropriate instructions in the Installing
vRealize Automation.
n
Log in to vRealize Automation Appliance Management as root using the password you entered when
you deployed the vRealize Automation appliance.
n
Install and configure an appropriate embedded Postgres appliance database cluster.
n
If your database uses synchronous replication mode, ensure that there are three active nodes in the
cluster.
Procedure
1 Remove the master node IP address from the external load balancer.
2 Isolate the master node.
Disconnect the node from its current network. This should be the network that is routing to the
remaining vRealize Automation appliance nodes.
3 Select another NIC for management, or manage it directly from the Virtual Appliance Management
Interface.
4 Select vRA Settings > Database on the Virtual Appliance Management Interface.
5 Select the replica node with the lowest priority for promotion to the master, and click Promote.
Replica nodes appear in ascending priority order.
The old master is demoted to replica status, and the new master is promoted.
6 Perform the appropriate replica maintenance.
Managing vRealize Automation
VMware, Inc. 34