Rwilliams: /* Upgrade to Recent Version that leverages MySQL5 */

2023-08-04T17:24:54Z

Upgrade to Recent Version that leverages MySQL5

← Older revision		Revision as of 17:24, 4 August 2023
Line 11:		Line 11:
	This step is critical as it puts the system in a known state for upgrading to MySQL8. A later version of MySQL5 supported Command Center is v123		This step is critical as it puts the system in a known state for upgrading to MySQL8. A later version of MySQL5 supported Command Center is v123

	Edit install.conf in the ~/~~cc\_install~~ directory and set the version as shown below		Edit install.conf in the ~/cc_install directory and set the version as shown below

	command_center_image_version=123		command_center_image_version=123

Rwilliams: Created page with "=Command Center Upgrade Including MySQL5 to MySQL8= '''THIS IS A WORK IN PROGRESS PLEASE CONSIDER THIS AS REFERENCE ONLY AT THIS TIME''' '''THERE MAY BE ISSUES PRESENT IN TH..."

2023-07-13T16:00:28Z

Created page with "=Command Center Upgrade Including MySQL5 to MySQL8= '''THIS IS A WORK IN PROGRESS PLEASE CONSIDER THIS AS REFERENCE ONLY AT THIS TIME''' '''THERE MAY BE ISSUES PRESENT IN TH..."

New page

=Command Center Upgrade Including MySQL5 to MySQL8=

'''THIS IS A WORK IN PROGRESS PLEASE CONSIDER THIS AS REFERENCE ONLY AT THIS TIME'''

'''THERE MAY BE ISSUES PRESENT IN THIS PROCEDURE CURRENTLY'''

The follow page walks through the process of upgrading from a system running MySQL5 to a new system running MySQL8. MySQL8 is considered the standard moving forward.

==Upgrade to Recent Version that leverages MySQL5==

This step is critical as it puts the system in a known state for upgrading to MySQL8. A later version of MySQL5 supported Command Center is v123

Edit install.conf in the ~/cc\_install directory and set the version as shown below

command_center_image_version=123

Run the UpdateCommandCenter shell script after making the change

sudo ./UpdateCommandCenter.sh

This will stop the currently running container, download the new images, install them, and restart the new version of the container. Confirm that everything is still working at this point to be sure that there are no errors.

There will still be the original container left after this is completed, it can be seen by performing the below command. Note that the new container is 85a37aa455c2 and the old one is df6dc735424a.

sudo docker container ls -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
85e37aa455c2 lingoport/command-center_dev:123 "catalina.sh run" 27 minutes ago Up 26 minutes 0.0.0.0:8083->8080/tcp, :::8083->8080/tcp jolly_bell
5debec9603c6 jenkins/jenkins:lts-jdk11 "/usr/bin/tini -- /u…" 2 weeks ago Exited (143) 44 hours ago competent_carson
df6dc7e5424a lingoport/command-center_dev:102 "catalina.sh run" 2 months ago Exited (143) 27 minutes ago strange_hawking
ea33ced44224 mysql:5.7 "docker-entrypoint.s…" 2 months ago Up 2 weeks 3306/tcp, 33060/tcp sad_lederberg

==Backup the MySQL5 Based DB==

Log into the MySQL Container

[ec2-user@ip-172-31-77-246 cc_install]$ sudo docker exec -it <CONTAINER ID> bash

Log into MySQL inside of the container and get the MySQL root password from the install.conf file

mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 105
Server version: 5.7.42 MySQL Community Server (GPL)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LRM |
| commandcenter |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)

There are two databases that contain the required data for the upgrade. One is LRM and the other is commandcenter as can be seen in the above output.

The directory /etc/mysql/conf.d is mounted as as a volume on the vm itself so it can be used as a location to place the backup file(s). On the VM it is mounted as /home/<USER>/mysql/conf.d

mkdir *etc/mysql/conf.d/db_backups*
mysqldump -u root -p --databases LRM commandcenter > /etc/mysql/conf.d/db_backups/lrm_cc_dbs.sql

Exit out of the shell in the container and return back to the virtual machine shell.

Move the db_backups directory on the VM to /home/<USER>/db_backups so it is easily available
mv /etc/mysql/conf.d/db_backups ~/

Stop the running docker containers for both Command Center and MySQL5 using the below command on each of their containers.

sudo docker stop <CONTAINER ID>

==Upgrade to the MySQL8 Based DB Version==

At this point, the latest version of the Command Center Installation software is needed so that MySQL8 can be installed. Note that there is a difference between the Installation scripts so its required to have an install script that supports MySQL8

Update the install.conf file to the next version "124" which will use MySQL8

command_center_image_version=124

Run the UpdateCommandCenter.sh to perform the upgrade, this time it will be built with MySQL8 support as we are using the new install script.

Copy the db_backups directory that was created prior back into the volume directory so it can be accessible from within the container

cp ~/db_backups ~/mysql/conf.d/db_backups

Log into the MySQL8 Container similar to before.

[ec2-user@ip-172-31-77-246 cc_install]$ sudo docker exec -it <CONTAINER ID> bash

Go to the /etc/mysql/conf.d/db_backups directory and install the backup from within the container

cd /etc/mysql/conf.d/db_backups
mysql -uroot -p < ./lrm_cc_dbs.sql

Exit out of the container shell and return back to the Virtual Machine

Confirm via web browser that its possible to log into Command Center using original credentials from MySQL5.7 system and that any existing projects are still present.

=New Backup Script Available=
There is a new Backup script that can be used to manually create a backup of this new system. Create the new directory prior to running it. It will store the backup in the home directory as shown.

/home/<USER>/commandcenter/backup/

Simply run from the cc_install directory

sudo ./BackupCommandCenterDatabase.sh

Now that everything is upgraded to MySQL8 and a backup has been created , its is possible to install later versions of Command Center. Go back to the install.conf file and set the version as desired. Once set, run the UpdateCommandCenter.sh script to upgrade to the desired version.

sudo ./UpdateCommandCenter.sh

Command Center Upgrade MySQL5 to MySQL8 - Revision history

Rwilliams: /* Upgrade to Recent Version that leverages MySQL5 */

Rwilliams: Created page with "=Command Center Upgrade Including MySQL5 to MySQL8= '''THIS IS A WORK IN PROGRESS PLEASE CONSIDER THIS AS REFERENCE ONLY AT THIS TIME''' '''THERE MAY BE ISSUES PRESENT IN TH..."