After you expand vRealize Automation to include the third vRealize Automation virtual appliance, change the replication method of the PostgreSQL database to synchronous mode. Synchronous mode for automatic failover with improved data loss protection.

Procedure

  1. Log in to the first vRealize Automation appliance.
    1. Open a Web browser and go to https://vra01svr01a.rainpole.local:5480
    2. Log in using the following credentials.

      Settings

      Value

      User name

      root

      Password

      vra_appA_root_password

  2. On the vRA Settings tab, click the Database button to review the current Replication Mode.
  3. Verify the following database settings.

    Setting

    Expected Value

    Replication Mode

    Database is in Asynchronous Mode

    Connection Status

    Connected

  4. Verify that the following hosts appear in the list of database nodes.

    Database Node Host

    Status

    vra01svr01a.rainpole.local

    Up

    vra01svr01b.rainpole.local

    Up

    vra01svr01c.rainpole.local

    Up

  5. Verify that each of the two replica hosts has the following configuration.

    Setting

    Expected Value

    Sync State

    Async

    Valid

    Yes

  6. Click the Sync Mode button to enable the synchronous replication mode of the PostgreSQL database.

    Wait until the Replication Mode updates.

  7. Verify the following database settings.

    Setting

    Expected Value

    Replication Mode

    Database is in Synchronous Mode. Automatic failover is now turned on!

    Connection Status

    Connected

  8. Verify that you see the hosts in Step 4.
  9. Verify that each of the two replica hosts has the following configuration.

    Setting

    Expected Value

    Sync State

    Sync

    Valid

    Yes