MYSQL 5.6.x RPM based upgrade process

This document can be used in following scenarios :

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

In this tutorial, we will upgrade MYSQL instance 5.6.24 installed using RPM in blog (Install MYSQL 5.6 using RPM on Linux server) to new version MYSQL 5.6.35

Quick High Level steps:

• Backup database - I used MEB(3.12) but Mysqldump or a cold backup is okay
• Shutdown the database cleanly. 
• Upgrade the binaries (rpm -Uvh) Start the database
• 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 NODE1 and then UNZIP it.

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

STEP 3: Upgrade the binaries of MYSQL(Note: client first then server)

rpm –qa |grep –i “mysql” /*To check current installed RPM*/
rpm –Uvh MySQL-client-advanced-5.6.34-1.el6.x86_64.rpm /*Client Upgrade*/
rpm –Uvh MySQL-server-advanced-5.6.34-1.el6.x86_64.rpm /*Server Upgrade*/

STEP 4: Start MYSQL and run mysql_upgrade 
/etc/init.d/mysql start
mysql_upgrade -uroot -pgoogle@123

STEP 5 : Login MYSQL and check upgraded version

mysql -uroot -pgoogle@123

\s

That’s it !!! You just upgraded MYSQL minor version with RPM based installation.