Post-upgrade steps
Follow these steps to perform the post-upgrade tasks for an upgrade to Moogsoft AIOps v7.3.x from v7.0.x, v7.1.x, or 7.2.x.
Refer to Upgrade Moogsoft AIOps for general information and upgrade instructions for other components and versions.
Upgrade the historic database
You must upgrade the historic database. This can be done after the main upgrade process has been completed and while the system is running.
The process runs in the background. It is separate from the main schema upgrade because for very large databases it can take several hours to complete. You can upgrade the historic database either before OR after you perform the migration from MySQL to Percona XtraDB Cluster.
To upgrade the historic database schema:
Run the
moog_historic_post_migrationscript with the valid arguments for your system, on a terminal dedicated to the process. Use the-hflag to see all available options. Allow the process time to finish. For example:$MOOGSOFT_HOME/bin/utils/moog_historic_post_migration.sh -H localhost -P 3306 -u root
Optionally, enable compression on the historic database snapshots table. Moogsoft recommends this if disk space is a concern.
This utility is documented here: Table Compression Utility
Note
This utility requires a number of Perl dependencies to run. The following commands can be run to install these dependencies (root required for the final 'yum' command):
curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-DBD-MySQL-4.023-6.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-DBI-1.627-4.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Data-Dumper-2.145-3.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Digest-1.17-245.el7.noarch.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Digest-MD5-2.52-3.el7.x86_64.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-IO-Compress-2.061-2.el7.noarch.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-Net-Daemon-0.48-5.el7.noarch.rpm; curl -L -O http://mirror.as29550.net/mirror.centos.org/7.6.1810/os/x86_64/Packages/perl-PlRPC-0.2020-14.el7.noarch.rpm; curl -L -O http://centos.mirroring.pulsant.co.uk/7.7.1908/os/x86_64/Packages/perl-IO-Socket-IP-0.21-5.el7.noarch.rpm; curl -L -O http://centos.mirroring.pulsant.co.uk/7.7.1908/os/x86_64/Packages/perl-IO-Socket-SSL-1.94-7.el7.noarch.rpm; curl -L -O http://centos.mirroring.pulsant.co.uk/7.7.1908/os/x86_64/Packages/perl-Mozilla-CA-20130114-5.el7.noarch.rpm; curl -L -O http://centos.mirroring.pulsant.co.uk/7.7.1908/os/x86_64/Packages/perl-Net-LibIDN-0.12-15.el7.x86_64.rpm; curl -L -O http://centos.mirroring.pulsant.co.uk/7.7.1908/os/x86_64/Packages/perl-Net-SSLeay-1.55-6.el7.x86_64.rpm; yum install *.rpm
After you have run these steps, you can re-run the Database Validator utility to confirm that the schemas are now in sync. See Validate the upgrade: Database components for details on how to run the utility.
Migrate the databases to Percona XtraDb Cluster and HA Proxy
Moogsoft AIOps uses Percona XtraDB Cluster which supports the Galera replication protocol to support high availability (HA). Percona XtraDB is similar to MySQL with improvements for HA, scalability, and usability.
Moogsoft strongly recommends you perform the migration from MySQL to Percona XtraDB Cluster and HAProxy. See Database Strategy for details behind the Moogsoft decision to use Percona and HAProxy.
To perform the migration, refer to the appropriate instructions, depending on your deployment type: