Database HA


CCM Installers are only available for AWS, OpenStack, and VMware clouds.

Exchange MGMTPOSTGRES SSH Keys

To exchange the SSH keys between the MGMTPOSTGRES_MASTER and MGMTPOSTGRES_SLAVE instances, follow this procedure.

  1. On the MGMTPOSTGRES_MASTER and MGMTPOSTGRES_SLAVE instances, execute the following commands to generate a new SSH key on each instance. 

    ssh-keygen -t rsa
    cd ~/.ssh
    cat id_rsa.pub >> authorized_keys
    chmod 600 authorized_keys
  2. Copy the id_rsa.pub content from both MGMTPOSTGRES instances and paste the content into the authorized_keys file.

  3. Verify mutual SSH access between the MGMTPOSTGRES_MASTER and MGMTPOSTGRES_SLAVE by running the following command on each VM.

    ssh root@<MGMTPOSTGRES_MASTER/MGMTPOSTGRES_SLAVE>

MGMTPOSTGRES_MASTER – Configure High Availability Properties

To configure high availability for MGMTPOSTGRES_MASTER, follow this procedure.

  1. Invoke the database wizard as a root user (see Virtual Appliance Process > Cloud-Specific Setup Details for a sample setup).

    MGMTPOSTGRES Wizard Path
    /usr/local/cliqr/bin/db_config_wizard.sh
  2. Configure Postgres HA to ensure the PostgreSQL database HA and enter the information in each field as follows:

    Write this down for future reference!

    Write down the Field details in a printed version of the Installation Approach > Your Notes section for later use.

    HA-Specific Wizard Setting

    Field

    Description

    Configure_Postgres_HA

    DB MasterThis value reflects the node1 or node2 details – this constant cannot be modified (not configurable).
    DB Master Private IPThe private IP address of the master database VM
    DB Slave HostnameThis value reflects the node1 or node2 details – this constant cannot be modified (not configurable).
    DB Slave Private IPThe private IP address of the slave database VM

    VIP or EIP 

    The VIP/EIP IP for the database.

    Use your mouse to select this option.

     AWS Cloud Nuances for EIP
    To setup the CloudCenter database to be an RDS instance, see Configuring an AWS Database.

    Once the details are entered, the database server begins replication configuration between the database servers followed by HA configuration and finally presents the following status messages.

    • Configuring database for HA ...
    • Configuring database for replication
  3. Exit the configuration wizard.

  4. Go to each PostgreSQL server and enter the following command to review the status of the database and the HA connectivity:

    pcs cluster status
    
    

    You can use the pcs cluster status command listed above or the pcs status command for both Steps 4a and 4b below. See https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/high_availability_add-on_reference/s1-clusterstat-haar for additional details on each command.

    1. Ensure that the PCSD Status for both database servers display Online in response to this command

    2. Ensure that the Daemon Status for Corosync, Pacemaker and the PCSD service are active/disabled. The active/disabled status indicates that PCS and Corosync services will be started on bootup as part of the cluster configuration process. This status ensures that the services start even if the Pacemaker service does not start the dependent services.



Back to: Database (Required)

  • No labels
© 2017-2019 Cisco Systems, Inc. All rights reserved