Remote Databases

[TBT]

We utilize remote databases for out Nagios XI instances and have a few questions.

DB failover question:

1. Currently, we have a primary Nagios database instance that is being replicated to a secondary database server. Is there any feature in Nagios that would allow Nagios to connect and use the secondary database server (as a hot failover) in the event of the primary database server becoming unavailable?

Replication question:

2. Are there any plugins available that could monitor the status of a MySQL replication slave server to see if it has stopped replicating?

Table Check question

3. What is the recommended method for checking/repairing tables in a Nagios database? Is there a mechanism in Nagios to do the checks, or is there a feature that could be enabled to stop writing to the database during a check/repair (ie. maintenance mode)

Please advise.

[avandemore]

1. There is not a supported option by Nagios but there are a number of unsupported methods of making MySQL HA.
2. There are some plugins and tutorials here: https://exchange.nagios.org/index.php?o ... eplication
3. Repairing the DB is covered in this document: https://assets.nagios.com/downloads/nag ... tabase.pdf Following it will shutdown the needed parts to run repairs safely.

[tmcdonald]

Just checking in since we have not heard from you in a while. Did @avandemore's post clear things up or has the issue otherwise been resolved?

[TBT]

Just checking in since we have not heard from you in a while. Did @avandemore's post clear things up or has the issue otherwise been resolved?

We're investigating mysqlfailover options. Might as well close this for the time being. Thanks.