Database Setup -- Still Supported ???

[chicjo01]

Looking if Nagios Team would still suppose this type of setup, due to my database departments standard practices?

Moving the data and structure of the 3 database instances (nagios, nagiosql, nagiosxi) into 1 big database instance (bignagios) will be supported by the Nagios Team or would get the response "We will not support this type of setup"???

If you are still confused or have questions. Please let me know.

--- Background Info ---
We have confirmed you can put all 3 database instances into one large database instance.

To remove confusion:
- The data and table structure of the 3 Database Instances (nagios, nagiosql, nagiosxi) are moved into one database instance.

Database Instance Names:
nagios
nagiosql
nagiosxi

Steps to Setup:
1) Download and install nagiosxi 5 using ./fullinstall
2) Follow Offloading MySQL Server Docs (https://assets.nagios.com/downloads/nag ... Server.pdf)
3) Move nagios, nagiosql, nagiosxi database instance into bignagios database instance
4) Follow Offloading MySQL Server Docs again using bignagios database instance

Diagram:
[img]nagios-db-collapse.png[/img]

[jdalrymple]

due to my database departments standard practices

I'd like to make you aware that your database department's standard practices aren't necessarily industry standards, although I'm certain you can't affect that:
https://www.google.com/search?q=databas ... 8&oe=utf-8

Moving the data and structure of the 3 database instances (nagios, nagiosql, nagiosxi) into 1 big database instance (bignagios) will be supported by the Nagios Team or would get the response "We will not support this type of setup"???

If it breaks, we'll help you fix it. If you want to upgrade and our upgrade tools can't handle your customizations, we won't rewrite the upgrade tools to handle your specific circumstances. If for some reason a report, plugin, component or whatever breaks, we will try to help fix it but cannot guarantee that the solution isn't actually to restore Nagios to a vanilla installation.

A final note - the nagios database (meaning nagios proper, not as a generalization) is a busy busy database ingesting all of the system events/alerts etc. It's been known to "fall behind." Generally speaking we see this effect cascading into the other databases already, but we're familiar with the symptoms and know what to look for when we see these performance issues crop up. If you slap them altogether we cannot be sure what the new symptoms will be. You may encounter new problems we've never seen before. To the best of my knowledge none of our customers have setup this configuration and as such MTTR for any upcoming issues will no doubt be increased as your system is quite likely to exhibit behavior our support staff has never seen.

That said - we always provide best effort support no matter how you configure your system. The concern would be that if it does create issues with XI we won't customize XI source code specific for your configuration, you'll have to revert to a known valid configuration.

[chicjo01]

Thank you for the information. I will bring this to my management and database team.

[rkennedy]

Sounds good, I will leave this thread open for now. Let us know if you have any other questions.