Question about databases open to all nagios users

[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

[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

[benhank]

thanks man!

[scottwilkerson]

thanks man!

can we lock it up?

[benhank]

yeah

[scottwilkerson]

yeah

Locking