Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning
titleCaution

Proceeding after this point without Version 3.15 or later of the jtel Portal installed, will break the database, and a rollback will be necessary.

Perform clean shutdown of MySQL with innodb_fast_shutdown set to 0

Code Block
mysql -u root -p<password> --execute="SET GLOBAL innodb_fast_shutdown=0"
mysqladmin -u root -p<password> shutdown

Enable 8.0 repoitories and update the server

...

Code Block
# Enable 8.x
yum-config-manager --disable mysql56-community
yum-config-manager --disable mysql57-community
yum-config-manager --enable mysql80-community

# Update to 8.x
yum update

Next restart the MySQL server.

Start the MySQL Server (WITHOUT REPLICATION FOR SLAVES AND MASTER-MASTER)

Start the mysql Server without replication.

Code Block
# Start - IMPORTANT - WITHOUT REPLICATION
systemctl set-environment MYSQLD_OPTS="--skip-slave-start"
systemctl start mysqld.service
Code Block
service mysqld restart


Warning
titlemysql_upgrade

mysql_upgrade is run automatically by all current 8.x versions of MySQL Server.

The output of mysql_upgrade can be found in /var/log/mysqld.log

Check this file for errors.

Next restart the MySQL server.

Code Block
systemctl stop mysqld.service
systemctl set-environment MYSQLD_OPTS=
systemctl start mysqld.service

Check Database and Replication are OK

Code Block
mysql -u root -p<password> -e "SHOW SLAVE STATUS\G"

Phase 4 - Configure Other Components

Update the JBOSS Server

The JBOSS server requires a new connector to attach to MySQL 8.x.

...