Update mariadb

[steph007]

Hi,

I have actually mariadb 5.5.68 and I want confirm that this is the way to upgrade it to the latest version?
https://www.tecmint.com/upgrade-mariadb ... an-ubuntu/

Any know bug or pitfall to avoid?


Note
I'm using NDO2 because I have issues at version 3.

[gsmith]

Hi,

Not knowing your OS, I have to throw out this disclaimer:

We build, test, and support what's provided by the Linux vendor such as RHEL or Ubuntu. If you would like to update beyond a version that's provided by the default repositories, you may run into issues with upgrades or other problems.

That procedure you referenced looks reasonable enough.

If you look at Nagios XI _ License Entitlements https://support.nagios.com/kb/article.php?id=145 you will see:

Every Nagios XI License key is valid for 3 installs, each with their own specific purpose. Each install is necessary to properly manage and maintain a fully functional monitoring implementation. The following install descriptions are listed below:

Production Install - The main monitoring install for a given license key. This is the install that system administrators use on their production servers and infrastructure to monitor their environment and receive notifications when systems are not working properly.

Test/Lab Environment - The second install is for use in a test environment. This ensures that when upgrades are necessary, or major configuration changes are implemented, there are not adverse effects to the main monitoring system. The test install allows teams to “preview” their changes without jeopardizing the main system.

Backup Install - Each Nagios XI license key may be used on one separate monitoring server that is designated as a disaster recovery (DR) instance, as long as the following condition is met:

The DR instance is in non-operational mode (e.g. it is not actively monitoring hosts and services), except when it assumes operation when the primary monitoring server fails.

You are STRONGLY advised to take advantage of this policy to create a Test system that you can use as a dry run for your
database migration.

As far as any specific "gotchas" are concerned, I am not aware of any, but you could search through the forum to see if any were encountered.

Thanks

[steph007]

Sorry, I'm on centos7. VM downloaded from your web site.

[gsmith]

Hi,

Here is what I could find for CentOS 7:

Screenshot 2021-04-19 093200.jpg

All the cautions and warnings from my previous reply still apply,
but from my experience the upgrade should be pretty smooth.

If you are going to MariaDB 10+ or MySQL 5.8+ you will need to do this to set sql_mode="":

https://support.nagios.com/kb/article/n ... n-822.html

Thanks

[steph007]

Thanks, you can close the ticket.
I will wait for the upgrade availabble from the default repositories of centos.

[scottwilkerson]

Thanks, you can close the ticket.
I will wait for the upgrade availabble from the default repositories of centos.

Locking thread