Tarball - Upgrade database components

Download the MySQL 5.7.36 tarball to the server:

curl -L -O https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.36-el7-x86_64.tar.gz

Check if MySQL is configured to run with --gtid-mode=ON using the following command in the MySQL CLI:

show variables like 'gtid_mode';

Remember what the value is because you will need it later.

Move the MySQL tarball into the desired location and extract it:

tar -xf mysql-5.7.36-el7-x86_64.tar.gz

Update the system PATH to point at the new MySQL folder. The command below assumes the new MySQL folder is in the same folder as the previous MySQL folder (user home). If this is not the case, you must manually update the ~/.bashrc file.

sed -i 's/5.7.3./5.7.36/g' ~/.bashrc;
source ~/.bashrc;

Update the ~/.my.cnf file to reflect the correct path for MySQL. Run the following commands to update this file. The commands below assumes the Database .my.cnf file is under the current user's 'home' folder.

MYSQL_HOME=$(dirname $(dirname $(which mysqld)))
sed -i "s;basedir.*;basedir = ${MYSQL_HOME};" ~/.my.cnf
sed -i '/\[mysqld\]/a log_bin_trust_function_creators = 1\nthread_stack = 524288\n' ~/.my.cnf

Restart MySQL:

$MOOGSOFT_HOME/bin/utils/process_cntl mysql restart

If the gtid-mode was OFF (based on the command run earlier in the upgrade), run the MySQL upgrade utility. Provide the MySQL root password when prompted or just press Enter if no password set.

mysql_upgrade -u root -p -S $(awk "NR>$(cat -un ~/.my.cnf | egrep '\[mysqld\]' | awk '{print $1}')" ~/.my.cnf | egrep 'socket\s*=' | head -1 | awk -F= '{print $2}')

If the gtid-mode was ON, you do not need to do this step.

See the MySQL documentation on restrictions on replication with GTIDs for more information.

Restart MySQL:

$MOOGSOFT_HOME/bin/utils/process_cntl mysql restart

Download the Percona 5.7.36 tarball file to the server:

curl -L -O https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.24/binary/tarball/percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12.tar.gz

curl -L -O https://downloads.percona.com/downloads/Percona-XtraDB-Cluster-57/Percona-XtraDB-Cluster-5.7.36-31.55/binary/tarball/Percona-XtraDB-Cluster-5.7.36-rel39-55.1.Linux.x86_64.glibc2.12.tar.gz

Check if Percona is configured to run with --gtid-mode=ON using the following command in the MySQL CLI:

show variables like 'gtid_mode';

Remember what the value is because you will need it later.

Move the Percona tarball files into the desired location and extract them:

tar -xf Percona-XtraDB-Cluster-5.7.36-rel39-55.1.Linux.x86_64.glibc2.12.tar.gz;
tar -xf percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12.tar.gz;

Update the system PATH to point at the new MySQL folder. The command below assumes the new MySQL folder is in the same folder as the previous MySQL folder (user home). If this is not the case, you must manually update the ~/.bashrc file.

sed -i 's;Percona-XtraDB-Cluster-5\.7[^/]\+;Percona-XtraDB-Cluster-5.7.36-rel39-55.1.Linux.x86_64.glibc2.12;' ~/.bashrc;
sed -i 's/percona-xtrabackup-[^/]\+/percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12/g' ~/.bashrc
source ~/.bashrc;

You must update the ~/.my.cnf file to reflect the correct path for MySQL. Run the following commands to update this file. The commands below assumes the Database .my.cnf file is under the current user's 'home' folder.

MYSQL_HOME=$(dirname $(dirname $(which mysqld)))
sed -i "s;basedir.*;basedir = ${MYSQL_HOME};" ~/.my.cnf
sed -i '/[mysqld]/a log_bin_trust_function_creators = 1\nthread_stack = 524288\n' ~/.my.cnf
sed -i "s;wsrep_provider\s*=.*;wsrep_provider = ${MYSQL_HOME}/lib/libgalera_smm.so;" ~/.my.cnf

Restart MySQL:

$MOOGSOFT_HOME/bin/utils/process_cntl mysql restart

If the gtid-mode was OFF (based on the command run earlier in the upgrade), run the MySQL upgrade utility. Provide the MySQL root password when prompted or just press Enter if no password set.

mysql_upgrade -u root -p -S $(awk "NR>$(cat -un ~/.my.cnf | egrep '\[mysqld\]' | awk '{print $1}')" ~/.my.cnf | egrep 'socket\s*=' | head -1 | awk -F= '{print $2}')

if the gtid-mode was ON, you do not need to do this step.

See the MySQL documentation on restrictions on replication with GTIDs for more information.

Restart MySQL:

$MOOGSOFT_HOME/bin/utils/process_cntl mysql restart

Identify the config files that have changed between the previously installed version and v8.0.x. Replace <previous_version> with the version installed previously, for example 7.3.1.1.

diff -rq $MOOGSOFT_HOME/dist/<previous_version>/config $MOOGSOFT_HOME/dist/8.0.*/config | grep -i 'differ'

Update files in $MOOGSOFT_HOME/config with any changes introduced in the v8.0.x versions of these files.

Identify the contrib files that have changed between the previously installed version and v8.0.x. Replace <previous_version> with the version installed previously for example 7.3.1.1.

diff -rq $MOOGSOFT_HOME/dist/<previous_version>/contrib $MOOGSOFT_HOME/dist/8.0.*/contrib | grep -i 'differ'

Update files in $MOOGSOFT_HOME/contrib with any changes introduced in the v8.0.x versions of these files.

Identify the bot files that have changed between the previously installed version and v8.0.x. Replace <previous_version> with the version installed previously, for example 7.3.1.1.

diff -rq $MOOGSOFT_HOME/dist/<previous_version>/bots $MOOGSOFT_HOME/dist/8.0.*/bots | grep -i 'differ'

Update files in $MOOGSOFT_HOME/bots with any changes introduced in the v8.0.x versions of these files.

Open the /etc/my.cnf file on the host running Percona MySQL.

If the variable is not in this file, run the following to add the variable to the file:

sed -i 's/\(innodb_autoinc_lock_mode.*\)/\1\nlog_bin_trust_function_creators = 1\n/' ~/.my.cnf

If the variable is already in the /etc/my.cnf file, set the variable to 1.

Once you have enabled the variable, restart the database:

$MOOGSOFT_HOME/bin/utils/process_cntl mysqld restart

Ensure the database is running, then execute the following command, replacing <MySQL-SuperUsername> with the username of your super user:

bash $MOOGSOFT_HOME/bin/utils/moog_db_auto_upgrader -t 8.0.0 -u <MySQL-SuperUsername>

Enter the password for the user.