As a vRealize Automation system administrator, you must perform an appliance database maintenance failover operation.

Before you begin

  • vRealize Automation is installed and configured according to appropriate instructions in the Installing vRealize Automation 7.2.

  • Log in to the vRealize Automation management console as root.

  • Install and configure an appropriate embedded Postgres appliance database cluster.

  • If your database uses synchronous replication mode, ensure that there are at least three active nodes in the cluster.

About this task

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.

Procedure

  1. Ensure that the current master node is up and running in preparation for maintenance.
  2. Select vRA Settings > Database on the Virtual Appliance Management Interface.
  3. Select the most suitable replica node for promotion to the master, and click Promote.

    The old master is demoted to replica status, and the new master is promoted.

  4. Perform the appropriate replica maintenance.
  5. When the maintenance is complete, ensure that the virtual appliance is running with network connectivity and that its HAProxy service is running.
    1. Log in to the vRealize Automation management console as root.
    2. Ensure that the replica node can be pinged, resolved by name, and has a recent status in the
  6. Click Reset for the replica node.

    This operation resets the database so that it is configured to replicate to the current master and resynchronizes the replica node with the latest haproxy configuration from the master node.

  7. Following successful reset, return the replica virtual appliance node IP address to the external virtual appliance load balancer IP address pool.
  8. Ensure that the replica node appears healthy on the Configure Postgres vRA Database table and that it can be pinged and resolved by name.