After upgrading, point the /opt/aspera/common/mysql/data back to the shared storage.
-
Run the following commands on both nodes to point the database to the shared storage:
# cd /opt/aspera/common/mysql
# mv ./data ./data.new
# ln -s /mysql_data ./data
# chown -h mysql.mysql ./data
# rm data.old
Verify the data folder points to the
mysql_data folder on the shared storage.
# ls -lah /opt/aspera/common/mysql/data
lrwxrwxrwx 1 mysql mysql 11 Sep 19 19:00 /opt/aspera/common/mysql/data -> /mysql_data
-
Replace the data on the shared storage with the upgraded data of one of the nodes:
# rm -rf /opt/aspera/common/mysql/data/*
# mv /opt/aspera/common/mysql/data.new/* /opt/aspera/common/mysql/data/
-
On one node, grant remote access to MySQL for both nodes:
Note: You must use the same password as the password set in the acm configuration file (/opt/aspera/acm/bin/acm). You can view the contents of the configuration file for the configured password or set a new password and change the configured password to the new password.
# asctl mysql:start
# asctl mysql:grant_remote_access "local_server_ip_address"
New password: password
Confirm new password: password
# asctl mysql:grant_remote_access "other_server_ip_address"
New password: password
Confirm new password: password
# asctl mysql:stop
-
Once you have completed all the steps above on both nodes, restart the cronjobs on both the nodes by uncommenting the jobs.
# crontab -e
* * * * * /opt/aspera/acm/bin/acm 10.0.71.21 20 > /dev/null 2>&1
30 3 * * * /opt/aspera/acm/bin/acmtl -b > /dev/null 2>&1
45 3 * * 7 echo -n "" > /opt/aspera/common/asctl/log/asctl.log > /dev/null 2>&1