Setting up Database Connectivity

  1. For the active/passive MySQL setup within an active/active cluster, open the following file: 
    /opt/aspera/orchestrator/config/database.yml
  2. 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
  3. 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.