Page 1 of 1
Offload Nagios DB to MariaDB HA server pair
Posted: Thu Jul 15, 2021 9:17 am
by tbarnett
Is there a recommended method for offloading the Nagios database to an HA pair of MariaDB servers?
Has anyone done this?
Tom
Re: Offload Nagios DB to MariaDB HA server pair
Posted: Thu Jul 15, 2021 9:30 am
by tbarnett
I'm looking at the MariaDB Replication and Galera products.
Has anyone done this?
Tom
Re: Offload Nagios DB to MariaDB HA server pair
Posted: Thu Jul 15, 2021 3:18 pm
by benjaminsmith
Hi Tom,
I haven't run across that set up to date and looked through the case history and not much there. If you're looking for a supported, high availability setup for Nagios XI, the LinBIt solution would be the recommended approach.
https://linbit.com/tech-guide/ha-nagios ... -on-rhel7/
Let us know if you have more questions.
Regards,
Benjamin
Re: Offload Nagios DB to MariaDB HA server pair
Posted: Mon Jul 19, 2021 12:21 pm
by tbarnett
Benjamin,
Correct me if necessary.
I understand that the Linbit solution would make the HA pair at the Linux level.
I'm trying to off load the MariaDB to another server and make that server an HA pair.
Would the Linbit solution improve the way the MariaDB is working?
thx
Tom
Re: Offload Nagios DB to MariaDB HA server pair
Posted: Tue Jul 20, 2021 10:00 am
by benjaminsmith
Hi Tom,
That's correct. The LinBit HA solution for Nagios XI, and may or may not improve MariaDB performance. Currently, Nagios XI does not have a HA feature, so this the best option for a commercially support HA solution.
Regarding, setting up a MySQL HA server pair, we do not have any official documentation on the process and I did not come across much case history on it for reference. I can put in a feature request for this type of deployment for XI, it's currently not on the product roadmap. Let me know.
--Benjamin