Page 1 of 1

Question about databases open to all nagios users

Posted: Tue Sep 18, 2018 2:24 pm
by benhank
So I am thinking about dumping postgresql and mysql and adopting/migrating to Mariadb as our database of choice.
But I wanted to ask the community for some advice:

If you have done this, have you noticed any stability or performance gains after converting to maria db?
or for all the seasoned db admins out there, are there any gotchas to be aware of if I decide to make the change?
That is, are there any gotchas involved with migrating mysql and postgresql to mariadb?
my environment is fairly robust with 2400 host checks and 13,000 service checks running every five mins or less.
and finaly are there any performance tweaks that I should be aware of that a mariadb admin would want to implement?
fell free to chime in everyone no answer is a bad answer =D

Re: Question about databases open to all nagios users

Posted: Tue Sep 18, 2018 4:22 pm
by ssax
I haven't really seen much difference in mysql vs mariadb performance in my personal experience.

Here is the KB article on converting:

https://support.nagios.com/kb/article/c ... i-560.html

The only caveats to using mariadb is that if you use mariadb 10+ you will need some fixes, see here:

https://support.nagios.com/forum/viewto ... 71#p217971

And here:

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

Re: Question about databases open to all nagios users

Posted: Wed Sep 19, 2018 10:10 am
by benhank
thanks man!

Re: Question about databases open to all nagios users

Posted: Wed Sep 19, 2018 4:17 pm
by scottwilkerson
benhank wrote:thanks man!
can we lock it up?

Re: Question about databases open to all nagios users

Posted: Thu Sep 20, 2018 8:43 am
by benhank
yeah

Re: Question about databases open to all nagios users

Posted: Thu Sep 20, 2018 8:51 am
by scottwilkerson
benhank wrote:yeah
Locking