Page 1 of 1
Update mariadb
Posted: Thu Apr 15, 2021 12:13 pm
by 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.
Re: Update mariadb
Posted: Thu Apr 15, 2021 4:12 pm
by 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
Re: Update mariadb
Posted: Sat Apr 17, 2021 9:34 am
by steph007
Sorry, I'm on centos7. VM downloaded from your web site.
Re: Update mariadb
Posted: Mon Apr 19, 2021 9:35 am
by 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
Re: Update mariadb
Posted: Tue Apr 20, 2021 7:59 am
by steph007
Thanks, you can close the ticket.
I will wait for the upgrade availabble from the default repositories of centos.
Re: Update mariadb
Posted: Tue Apr 20, 2021 8:25 am
by scottwilkerson
steph007 wrote:Thanks, you can close the ticket.
I will wait for the upgrade availabble from the default repositories of centos.
Locking thread