Upgrade to MariaDB 10.11

Prerequisites Copied

Warning

Ensure you are upgraded to Opsview 6.11.1 before performing the upgrade.

Note

If your MariaDB package is sourced from the MariaDB repository instead of the OS repository, this upgrade will change it to use the OS repository.

Before upgrading the database, carefully review if your operating system is compatible with MariaDB 10.11. Refer to Supported databases for more information.

Back up Opsview Monitor databases and configuration Copied

Warning

This step is crucial to prevent data loss in your Opsview system.

Please refer to the Common Tasks page for more information.

Edit /opt/opsview/coreutils/etc/opsview.conf to check or set the correct backup destination in the variable $backup_dir.

Upgrade to MariaDB 10.11 Copied

1. Add the following configuration to the user_vars.yml file.

   opsview_database_package_vendor: 'mariadb'
   opsview_database_package_version: '10.11'
   

2. Run the check-deploy and setup-everything playbooks to upgrade the databases to MariaDB 10.11

   cd /opt/opsview/deploy
   ./bin/opsview-deploy lib/playbooks/check-deploy.yml
   ./bin/opsview-deploy lib/playbooks/setup-everything.yml
   

Restore the database backup Copied

To restore the backup of an Opsview Monitor database, identify the required file to restore from. The backup files can be found in $backup_dir. Note that you will have to restore your opsview, runtime, and dashboard databases.

Run setup-monitoring Copied

Note

Ensure you have successfully restored all your databases before executing this step.

Run the setup-monitoring playbook to apply recent changes to your database.

Do not forget to perform Apply Changes.