Running MySQL on a Separate Machine

After you have installed Console, you can further configure it to run the MySQL database on a remote machine. Follow these steps to run the web application and the MySQL database on two separate machines:

Note: This setup procedure involves steps on the Console machine and the MySQL machine. A MySQL machine or Console machine is indicated at each step.
  1. (MySQL machine) Download and install common files only
    On the MySQL machine, download Aspera Common Files and run it with the following command:
    $ rpm -Uvh aspera-common-version.rpm
  2. (MySQL machine) Setup MySQL database.

    On the MySQL machine, execute this command to configure MySQL:

    asctl mysql:setup

    When started, the configuration program will ask you to use streamlined or detailed setup. Expect the following setup items in each setup method: (In detailed setup, answer y in the first question.)

    Item Streamlined Detailed
    MySQL will run on this machine (y/n)? (default: y)   X
    What port would you like MySQL to listen on? (default: 4406) X X
    Where would you like MySQL to store data: (default: C:/Program files/Common Files/Aspera/Common/myql/data)   X
    MySQL will need to start/restart during configuration. Continue (y/n)? (Current: y) X X

    Lastly, a setup summary shows your settings. Enter y to confirm, n to change settings, or x to quit the program without saving.

    When finished, execute this command to allow access for the Console machine. Replace the highlighted items to match your configuration (Enter the Console machine's address in <Console_server_IP>, and your MySQL password in <mysql_password>):

    asctl mysql:grant_remote_access <Console_server_IP> root <mysql_password>
  3. (Console machine) Configure Console to use a remote MySQL database.

    On the Console machine, execute this command to configure it to run MySQL on a remote machine:

    $ asctl console:setup

    Answer n to the following question:

    MySQL will run on this machine (y/n)? (default: y)