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.
-
(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
-
(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>
-
(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)