You can use the Virtual Appliance Management Interface Database page to monitor or update the configuration of the appliance database. You can also use it to change the master node designation and the synchronization mode used by the database.

Before you begin

  • Install and configure vRealize Automation according to appropriate instructions in Installing vRealize Automation.

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

  • Configure an appropriate embedded Postgres appliance database cluster as part of your vRealize Automation deployment.

About this task

The appliance database is installed and configured during vRealize Automation system installation and configuration, but you can monitor and change the configuration from the Database tab on the Virtual Appliance Management Interface.

The Connection Status text box indicates whether the database is connected to the vRealize Automation system and is functioning correctly.

If your appliance database uses multiple nodes to support failover, the table at the bottom of the page displays the nodes, and their status and indicates which node is the master. The Replication mode text box shows the currently configured operation mode for the system, either synchronous or asynchronous. Use this page to update appliance database configuration.

The Sync State* column in the database nodes table shows the synchronization method for the cluster. This column works with the Status column to show the state of cluster nodes. Potential status differs depending on whether the cluster uses asynchronous or synchronous replication.

Table 1. Sync State for Appliance Database Replication Modes

Mode

Sync State Message

Synchronous replication

Master node - no status

Replica node - sync

Other nodes - potential

Asynchronous replication

Master node - no status

Other nodes - potential

The Valid column indicates whether replicas are synchronized with the master node. The master node is always valid.

The Priority column shows the position of replica nodes in relation to the master node. The master node has no priority value. When promoting a replica to become the master, select the node with the lowest priority value.

When operating in synchronous mode, vRealize Automation invokes automatic failover. In the event of master node failure the next available replica node will automatically become the new master. The failover operation requires 10 to 30 seconds on a typical vRealize Automation deployment.

Procedure

  1. On the Virtual Appliance Management Interface, select vRA Settings > Database.
  2. If your database uses multiple nodes, review the table at the bottom of the page and ensure that the system is operating appropriately.
    • Ensure that all nodes are listed.

    • Ensure that the appropriate node is the designated master node.

    Note:

    Do not click Sync Mode to change the synchronization mode of the database unless you are certain that your data is secure. Changing the sync mode without preparation may cause data loss.

  3. To promote one of the nodes to be the master, click Promote in the appropriate column.
  4. Click Save Settings to save your configuration if you have made any changes.