Setting up Database Connectivity

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

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

Update the parameter entries database.yml with values that are appropriate for your system.

Note: For installations with Ruby 2.3.0, you may need to edit the default values for the primary_host and alternate_host entries.

File entries for an installation with Ruby 2.3.0:

development:
  host: 127.0.0.1
  port: 4406
  primary_host: ip_address_primary_host
  alternate_host: ip_address_alternate_host
  adapter: mysql2
  username: root
  password: aspera
  database: orchestrator
  checkout_timeout: 1
  pool: 10
test:
  host: 127.0.0.1
  port: 4406
  primary_host: ip_address_primary_host
  alternate_host: ip_address_alternate_host
  adapter: mysql2
  username: root
  password: aspera
  database: orchestrator_test
  checkout_timeout: 1
  pool: 10
production:
  host: 127.0.0.1
  port: 4406
  primary_host: ip_address_primary_host
  alternate_host: ip_address_alternate_host
  adapter: mysql2
  username: root
  password: aspera
  database: orchestrator
  checkout_timeout: 1
  pool: 10

File entries for an installation with Ruby 1.8.7:

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