Lab8c

Upgrade 5.X to 8.0

• In place upgrade
• Custom upgrade

In-place upgrade (RPM)

Use OCI to demo the RPM upgrade

5.6 -> 5.7 -> 8.0

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
sudo yum-config-manager --disable mysql80-community
sudo yum install mysql-community-* --disablerepo=mysql* --enablerepo=mysql56-community
sudo systemctl start mysqld
mysql
sudo systemctl stop mysqld
sudo yum upgrade mysql-community-* --disablerepo=mysql* --enablerepo=mysql57-community
sudo systemctl start mysqld
sudo mysql_upgrade
sudo systemctl restart mysqld
sudo yum install mysql-shell
mysqlsh
dba.deploySandboxInstance(3310)
dba.deploySandboxInstance(3320)
dba.deploySandboxInstance(3330)
dba.createCluster('myCluster')
var x = dba.getCluster('myCluster')
x.addInstance('root@localhost:3320')
x.addInstance('root@localhost:3330')
x.status()
dba.stopSandboxInstance(3320)
x.status()
dba.startSandboxInstance(3320)
x.status()
x.rejoinInstance('root@localhost:3320')
mysqlsh -- util checkForServerUpgrade root@localhost --config-path=/etc/my.cnf
sudo yum upgrade mysql-community-* --disablerepo=mysql* --enablerepo=mysql80-community
sudo yum remove mysql-community-* mysql-shell-*

Custom Install

sudo systemctl stop mysqld
cd /usr/local/
ll
lab
cd mysql5
. ./comm.sh

# start mysql56 3309
mysqld --defaults-file=config/my1.cnf &
mysql -uroot -h127.0.0.1 -P3309
mysqladmin -uroot -h127.0.0.1 -p -P3309 shutdown

# start mysql57 3310
cd ~/data
cp -R mysql56 mysql57
cd /usr/local
sudo unlink /usr/local/mysql
sudo ln -s /opt/mysql-advanced-5.7.30-linux-glibc2.12-x86_64/ /usr/local/mysql
lab
cd mysql5
. ./comm.sh
mysqld --defaults-file=config/my2.cnf &
mysql -uroot -h127.0.0.1 -P3310
mysql_upgrade -u root -h 127.0.0.1 -P3310
mysqladmin -uroot -h127.0.0.1 -p -P3310 shutdown

# start mysql80 3320
cd ~/data
cp -R mysql57 mysql80
cd /usr/local
sudo unlink /usr/local/mysql
sudo ln -s /opt/mysql-commercial-8.0.20-el7-x86_64/ /usr/local/mysql
lab
cd mysql5
. ./comm.sh
mysqld --defaults-file=config/my3.cnf &
mysql
mysqlsh
\c root@localhost:3320
dba.deploySandboxInstance(3370)
dba.deploySandboxInstance(3380)
dba.deploySandboxInstance(3390)
dba.createCluster('myCluster')
var x = dba.getCluster('myCluster')
x.addInstance('root@localhost:3380')
x.addInstance('root@localhost:3390')
x.status()
dba.stopSandboxInstance(3380)
x.status()
dba.startSandboxInstance(3380)
x.status()