Moogsoft Docs

Database Strategy

As part of our ongoing investment into Moogsoft AIOps, we have made changes to our database strategy and methodology for v7.3.x.

Database products in use

In Moogsoft AIOps v7.3.x the following database products are in use:

  • Percona XtraDB Cluster 5.7 replaces Oracle MySQL CE.

  • HA Proxy is a new component, supporting features such as query routing to available database targets and load balancing.

  • Percona XtraBackup 2.4.4 replaces MySQL Dump to improve the efficiency of database backups.

Why Percona?

Percona XtraDB Cluster is a high availability (HA) variant of Percona Server that supports the Galera replication protocol.

MySQL Community technology was the original database foundation for Moogsoft AIOps. Percona Server offers improved high availability, scalability and functionality yet is based on the same code base, in fact the code is 99% identical. The differences are focused on high availability, scalability and usability which are key Moogsoft AIOps database requirements.

Performance enhancements for Oracle's MySQL are also added to Percona, usually shortly after the Oracle release cycle. For exact details of platform and version support, including EOL dates, refer to Percona Software and Platform Lifecycle.

Migrating from MySQL to Percona

See for instructions on how to migrate from MySQL to Percona. Perform the migration after you upgrade to Moogsoft AIOps v7.3.x.

Moogsoft's dedicated team of support personnel are on hand to answer any questions you may have about the migration process. Our service and support teams can also guide you if you require direct assistance during the migration process. Contact support for more information.

Configuring a Percona cluster is an intensive operation. The primary (donor) node may not be able to accept write actions during the period in which the data is copied to the second node. Therefore the downtime is determined by the size of the database. You can use the database compression tool to reduce downtime during the migration. See the Table Compression Utility for more information.

Database support

Moogsoft AIOps v7.3.x is only supported on Percona XtraDB Cluster 5.7. If you are upgrading to v7.3.x from a previous version of Moogsoft AIOps, Moogsoft strongly recommends that you migrate to Percona XtraDB Cluster 5.7.

Moogsoft AIOps v7.3.x is designed around Percona XtraDB XCluster as an integral component of the installation and upgrade process. This not only improves the migration process to v7.3.x but future versions of Moogsoft AIOps as well.

All database enhancements and improvements will be delivered through Percona XtraDB Cluster. Database support for previous versions of Moogsoft AIOps remains unchanged.