Nagios XI Offload MYSQL to a Remote Server

[tony]

I am having issues offloading Mariadb to a remote server
Running Nagios XI version 5-4-11 with Mariadb and no PostgreSQL

Followed the instructions in the document to offload MySQL
- https://assets.nagios.com/downloads/nag ... Server.pdf

The database is successfully offloaded to the remote server and Nagios XI GUI works.

However having issues stopping the mariadb service from loading / running - when I restart the server - the mariadb.service starts again

I have very little Redhat 7 experience - so how do I stop of this service from running.

Have tried the following

- systemctl stop mariadb.service
- systemctl disable mariadb.service
- systemctl --system daemon-reload
- Restart server

But the mariadb service keeps starting !

Also tried removing the mariadb.service from the After line in the /usr/lib/system/system/ndo2db.service

So why do the above systemctl lines not stop the mariadb service from starting or what else is starting it?

[kyang]

Make a backup or a snapshot of your current XI server before doing this. Just in case anything happens.

You could remove MariaDB, that way it won't restart, since you offloaded your DB to a remote server.

Run this command.

Code: Select all

yum remove mariadb

MariaDB should not start on your XI server if you reboot now.

Let us know if this helps you.

[tony]

I would like to keep mariadb install on the Nagios XI server in case I ever need to fall back to it.

How else could I stop the mariadb service from starting?

[lmiltchev]

Try removing this line:

Code: Select all

Wants=mariadb.service

from the "/usr/lib/systemd/system/ndo2db.service" file.

Alternatively, you could comment it out, so that it is going to look like this:

Code: Select all

# Wants=mariadb.service

Note: Systemd will attempt to start any units listed under the "Wants" directive, even though the service may be disabled. Let us know if this helped.

[tony]

Excellent - this worked - thanks a lot

[lmiltchev]

I am glad I could help!