How to upgrade MySQL bundled with Faspex on Linux


The current release of Faspex is 3.9.2, and that ships with MySQL 5.1 inside the "Common" package. Some security organizations insist on a much more recent version of MySQL. Here is how to upgrade the MySQL that comes bundled with Faspex. This example uses the Linux OS and MySQL 5.5.43

Required packages


(if needed)

I. Preliminary Steps

1. Backup existing Faspex database 

# asctl faspex:backup_database 

(This will create a standard MySQL dump file at /opt/aspera/faspex/backup/dated_folder/faspex.sql)

2. Backup existing Faspex configuration
* Log into the Faspex UI as *faspex-admin* 
* Choose *Server*–> *Configuration*–> *Save/Restore* 
* Use the *Download* button to download the existing Faspex configuration folder and database 

(This configuration save can only be restored via the Faspex UI)

3. Stop all Aspera services 

* # asctl all:stop 
* # /etc/init.d/asperacentral stop 
* # /etc/init.d/asperanoded stop 

4. Uninstall old mysql libraries 

* # rpm -e mysql-libs-5.1.73-3.el6_5.x86_64 

5. Check for libaio dependency 

* # rpm -q –provides libaio


II. Install New Packages

1. Install libaio libraries, if needed

 * # rpm -i libaio-0.3.107-10.el6.x86_64.rpm 

2. Install MySQL RPMs 

* # rpm -i MySQL-client-5.5.43-1.el6.x86_64.rpm 
* # rpm -i MySQL-shared-compat-5.5.43-1.el6.x86_64.rpm 
* # rpm -i MySQL-shared-5.5.43-1.el6.x86_64.rpm 
* # rpm -i MySQL-test-5.5.43-1.el6.x86_64.rpm 
* # rpm -i MySQL-embedded-5.5.43-1.el6.x86_64.rpm 
* # rpm -i MySQL-server-5.5.43-1.el6.x86_64.rpm


 III. Configuration Changes

1. Create /etc/my.cnf file 

* # vi /etc/my.cnf *(See Appendix)* 

2. Make a backup copy of /opt/aspera/common/mysql/share/mysql/mysql.server 

* # cp /opt/aspera/common/mysql/share/mysql/mysql.server /opt/aspera/common/mysql/share/mysql/mysql.server.BAK 

3. Copy the new mysql.server file to /opt/aspera/common/mysql/share/mysql 

* # cp /usr/share/mysql/mysql.server /opt/aspera/common/mysql/share/mysql/mysql.server 

4. Edit the /opt/aspera/faspex/config/database.yml file to refer to the new MySQL bin directory 

* # vi /opt/aspera/faspex/config/database.yml *(See Appendix)* 

5. Set a password for the root MySQL user 

* # mysqladmin -u root password wxxxxxxxxx2 


IV. Start MySQL and Verify

1. Start Faspex MySQL services 

* # asctl mysql:start 

2. Verify Faspex is using the new MySQL version 

* # /opt/aspera/common/mysql/bin/mysql -u root -p 
* Enter password set on step 3-5
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 37 
Server version: 5.5.43 MySQL Community Server (GPL)


V. Create Databases and Import Data

1. Create faspex database 

* mysql>create database faspex; 

2. Verify Faspex database was created 

* mysql>show databases; 

3. Select Faspex database 

* mysql>use faspex; 

4. Restore backup data from step 1-1 

* mysql>source /opt/aspera/faspex/backup/dated_folder/faspex.sql 

5. Verify data import 

* mysql>show tables; 

6. Quit the MySql client

* mysql>quit


VI. Start Services

1. Start all Aspera services 

* # asctl all:restart 
* # /etc/init.d/asperacentral stop 
* # /etc/init.d/asperanoded stop








encoding: utf8 
port: 4406 
username: root 
adapter: mysql 

mysql_bin_dir: /usr/bin
database: faspex 
user: root 
password: wxxxxxxxxx2


Powered by Zendesk