Setting up Database Connectivity

For the active/passive MySQL setup within an active/active cluster, add in the database.yml file at each node in the following directory:

/opt/aspera/orchestrator/config/

In the file, database.yml, edit the primary_host and alternate_host entries per the example below.

development:  
    host: localhost  
    port: 4406  
    primary_host: ip_of_host_1  
    alternate_host: ip_of_host_2 
    adapter: mysql  
    username: root  
    password: aspera  
    database: orchestrator 
production:  
    host: localhost  
    port: 4406  
    primary_host: ip_of_host_1  
    alternate_host: ip_of_host_2  
    adapter: mysql  
    username: root  
    password: aspera  
    database: orchestrator

Copy database.yml to the following directory:

/opt/aspera/var/config/orchestrator/

Run the following command:h

$ cp database.yml /opt/aspera/var/config/orchestrator

This step ensures that the data is preserved and preserved during an upgrade.