How to upgrade MySQL bundled with Faspex on Linux

Introduction

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

MySQL-5.5.43-1.el6.x86_64.rpm-bundle.tar 
<http://dev.mysql.com/downloads/mysql/>

libaio-0.3.107-10.el6.x86_64.rpm 
<http://dmt-bu2.us.oracle.com/wiwiki/lib/exe/fetch.php?id=mysql&cache=cache&media=libaio-0.3.107-10.el6.x86_64.rpm
(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

 

Appendix

*/etc/my.cnf*

[client] 
port=4406 
socket=/tmp/mysql.sock

[mysqld] 
port=4406 
socket=/tmp/mysql.sock 
key_buffer_size=16M 
max_allowed_packet=8M

[mysqldump] 
quick

 

*/opt/aspera/faspex/config/database.yml
production: 
encoding: utf8 
port: 4406 
username: root 
adapter: mysql 

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

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk