MYSQL 5.6.x TARBALL based upgrade process

This document can be used in following scenarios :

• MySQL Major version upgrade TARBALL based 
• MySQL Minor version upgrade TARBALL based 
• MySQL Security Patch apply TARBALL based 

In this tutorial, we will upgrade MYSQL instance 5.6.26 installed using TARBALL in blog (Install MYSQL 5.6 using TARBALL) on Linux server to new version MYSQL 5.6.34

Quick High Level steps:

• Backup database - I used MEB(3.12) but Mysqldump or a cold backup is okay
• Shutdown the database cleanly. 
• UNTAR new binaries to specified location
• Start MYSQL with new home and set environment 
• Run mysql_upgrade for new release

Detailed Low Level steps:

STEP1: Download correct binary from Oracle and move to target machine, in our case its NODE2 and then UNZIP it.

STEP 2: Take full backup of instance and shutdown instance gracefully

STEP 3: Make directory for new binaries and extract “UNTAR” software at the location
mkdir -p /usr/mysql/5.6.34
tar -xvzf mysql-advanced-5.6.34-linux-glibc2.5-x86_64.tar.gz -C /usr/mysql/5.6.34

    . 

    . 

    .

    . 

STEP 4: Go to the new binaries directory location & start the MySQL instance.
cd /usr/mysql/5.6.34/mysql-advanced-5.6.34-linux-glibc2.5-x86_64/
bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

STEP 5: Check if MYSQL process has been started from new home(5.6.34)
ps -ef|grep mysql

STEP 6: Upgrade the MYSQL start/stop script for new home
cd /etc/init.d/
vim mysql

STEP 7: Export new binary path and update new path in .profile for future access
export PATH=$PATH:/usr/mysql/5.6.34/mysql-advanced-5.6.34-linux-glibc2.5-x86_64/bin
which mysql

STEP 8: Run mysql_upgrade using new home
cd /usr/mysql/5.6.34/mysql-advanced-5.6.34-linux-glibc2.5-x86_64/
bin/mysql_upgrade -uroot –pgoogle@123 --port=3306

STEP 9: Restart MYSQL and check upgraded version

/etc/init.d/mysql restart

\s

That's All !! YOUR  INSTANCE UPGRADED SUCESSFULLY !!!