Database on Virtual Machine

[[email protected]]

Hello,
We are currently running our database locally on our Nagios XI box. We are running into space/peformance issues and our services/hosts size is increasing significantly to where we know we'll require a seperate database box. Is running the db on a VM acceptable? Or does it have to be a physical box? Anyone have any experience / input on this point? We'd prefer to stand it up on VM instance.
Thanks

[benjaminsmith]

Hi,

What is the current check load on the server ( total number of hosts and services) and how many additional checks will you be adding in the future.

Offloading the database can help but it does make the system more complex. I would start by making sure you have sufficient CPU and memory and have optime the settings in Nagios XI and then take the next steps.

Maximizing Performance In Nagios XI

Nagios XI - Optimizing The PHP Settings File

Regards,
Benajmin

[[email protected]]

Thanks for your reply. We are currently migrating out existing small Nagios Core over to Nagios XI but then will also be sunsetting CA UIM Nimsoft and SCOM. We have an additional legacy custom application monitoring tool we'll be replacing with Nagios XI as well. So in the next few months our total host/services check load will be roughly:

Hosts: 2000
Services: 10000

So we need to plan for that load now. We have reviewed our settings per the attached documents below. Using SMART option for check scheduling as well.

Thanks

[[email protected]]

Oh, and can you confirm that offloading to a VM is acceptable/doesn't pose any technical issues (if sized appropriately) v. a physical server?

[benjaminsmith]

Hi,

We are currently migrating out existing small Nagios Core over to Nagios XI but then will also be sunsetting CA UIM Nimsoft and SCOM. We have an additional legacy custom application monitoring tool we'll be replacing with Nagios XI as well.

Sounds good. If this is a new license, just want to let you know that we do offer a free QuickStart session with one of our engineers to help you get this off the ground.

Nagios XI Quickstart

Regarding, the offloaded database, we have many customers running XI in virtualized environments so this is not an issue.

Overall, that's a moderately sized check load. If you're running into performance issues, I can certainly review the system profile for you to make sure everything looks good.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.

[[email protected]]

Hello,
Wanted to update ticket so you know we haven't lost sight of it. Having to run the fix on Download Profile. Waiting for a change window to do so and will update ticket shortly with our system profile information. I'll definitely review the Quick Start documentation as well.
Thank you!

[benjaminsmith]

HI,

Sounds good.

We'll keep this open and just update us when you're ready.

[[email protected]]

Requested attachment has been attached.

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

[ssax]

Let's check the size of your databases:

Please send the output of these commands:
- NOTE: You may need to adjust the -uroot and the -pnagiosxi in the command if you've changed the root mysql password:

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

[[email protected]]

FYI - I did complete the Nagios XI QuickStart on-line form. Any idea when I can expect to hear from someone regarding that request?