Setting up Database Connectivity

For the active/passive MySQL setup within an active/active cluster, open the following file:

/opt/aspera/orchestrator/config/database.yml

In the file, edit the primary_host and alternate_host entries according to the example below.

development:  
    host: localhost  
    port: 4406  
    primary_host: ip_address_of_host_1  
    alternate_host: ip_address_of_host_2 
    adapter: mysql  
    username: root  
    password: aspera  
    database: orchestrator 
    wait_timeout: 1
    pool: 10
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
    wait_timeout: 1
    pool: 10

Copy database.yml to the following directory:

/opt/aspera/var/config/orchestrator/

Run the following command:

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

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