Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Nagios - distributed environment

https://support.nagios.com/forum/viewtopic.php?t=22297

Page 2 of 3

Re: Nagios - distributed environment

Posted: Thu Jan 16, 2014 8:30 pm
by MSPk
Thanks for the reply..what all things are offloded when we offload the MySQL DB??

Re: Nagios - distributed environment

Posted: Fri Jan 17, 2014 12:11 pm
by slansing
Hey MSPk,

When you offload the MYSQL databases, you will be transferring the Nagios, and NagiosQL DB's.

Nagios DB tables:

Code: Select all

+----------------------------------------+
| Tables_in_nagios                       |
+----------------------------------------+
| nagios_acknowledgements                |
| nagios_commands                        |
| nagios_commenthistory                  |
| nagios_comments                        |
| nagios_configfiles                     |
| nagios_configfilevariables             |
| nagios_conninfo                        |
| nagios_contact_addresses               |
| nagios_contact_notificationcommands    |
| nagios_contactgroup_members            |
| nagios_contactgroups                   |
| nagios_contactnotificationmethods      |
| nagios_contactnotifications            |
| nagios_contacts                        |
| nagios_contactstatus                   |
| nagios_customvariables                 |
| nagios_customvariablestatus            |
| nagios_dbversion                       |
| nagios_downtimehistory                 |
| nagios_eventhandlers                   |
| nagios_externalcommands                |
| nagios_flappinghistory                 |
| nagios_host_contactgroups              |
| nagios_host_contacts                   |
| nagios_host_parenthosts                |
| nagios_hostchecks                      |
| nagios_hostdependencies                |
| nagios_hostescalation_contactgroups    |
| nagios_hostescalation_contacts         |
| nagios_hostescalations                 |
| nagios_hostgroup_members               |
| nagios_hostgroups                      |
| nagios_hosts                           |
| nagios_hoststatus                      |
| nagios_instances                       |
| nagios_logentries                      |
| nagios_notifications                   |
| nagios_objects                         |
| nagios_processevents                   |
| nagios_programstatus                   |
| nagios_runtimevariables                |
| nagios_scheduleddowntime               |
| nagios_service_contactgroups           |
| nagios_service_contacts                |
| nagios_service_parentservices          |
| nagios_servicechecks                   |
| nagios_servicedependencies             |
| nagios_serviceescalation_contactgroups |
| nagios_serviceescalation_contacts      |
| nagios_serviceescalations              |
| nagios_servicegroup_members            |
| nagios_servicegroups                   |
| nagios_services                        |
| nagios_servicestatus                   |
| nagios_statehistory                    |
| nagios_systemcommands                  |
| nagios_timedeventqueue                 |
| nagios_timedevents                     |
| nagios_timeperiod_timeranges           |
| nagios_timeperiods                     |
+----------------------------------------+
NagiosQL tables:

Code: Select all

+--------------------------------------------+
| Tables_in_nagiosql                         |
+--------------------------------------------+
| tbl_command                                |
| tbl_contact                                |
| tbl_contactgroup                           |
| tbl_contacttemplate                        |
| tbl_domain                                 |
| tbl_host                                   |
| tbl_hostdependency                         |
| tbl_hostescalation                         |
| tbl_hostextinfo                            |
| tbl_hostgroup                              |
| tbl_hosttemplate                           |
| tbl_info                                   |
| tbl_lnkContactToCommandHost                |
| tbl_lnkContactToCommandService             |
| tbl_lnkContactToContactgroup               |
| tbl_lnkContactToContacttemplate            |
| tbl_lnkContactToVariabledefinition         |
| tbl_lnkContactgroupToContact               |
| tbl_lnkContactgroupToContactgroup          |
| tbl_lnkContacttemplateToCommandHost        |
| tbl_lnkContacttemplateToCommandService     |
| tbl_lnkContacttemplateToContactgroup       |
| tbl_lnkContacttemplateToContacttemplate    |
| tbl_lnkContacttemplateToVariabledefinition |
| tbl_lnkHostToContact                       |
| tbl_lnkHostToContactgroup                  |
| tbl_lnkHostToHost                          |
| tbl_lnkHostToHostgroup                     |
| tbl_lnkHostToHosttemplate                  |
| tbl_lnkHostToVariabledefinition            |
| tbl_lnkHostdependencyToHost_DH             |
| tbl_lnkHostdependencyToHost_H              |
| tbl_lnkHostdependencyToHostgroup_DH        |
| tbl_lnkHostdependencyToHostgroup_H         |
| tbl_lnkHostescalationToContact             |
| tbl_lnkHostescalationToContactgroup        |
| tbl_lnkHostescalationToHost                |
| tbl_lnkHostescalationToHostgroup           |
| tbl_lnkHostgroupToHost                     |
| tbl_lnkHostgroupToHostgroup                |
| tbl_lnkHosttemplateToContact               |
| tbl_lnkHosttemplateToContactgroup          |
| tbl_lnkHosttemplateToHost                  |
| tbl_lnkHosttemplateToHostgroup             |
| tbl_lnkHosttemplateToHosttemplate          |
| tbl_lnkHosttemplateToVariabledefinition    |
| tbl_lnkServiceToContact                    |
| tbl_lnkServiceToContactgroup               |
| tbl_lnkServiceToHost                       |
| tbl_lnkServiceToHostgroup                  |
| tbl_lnkServiceToServicegroup               |
| tbl_lnkServiceToServicetemplate            |
| tbl_lnkServiceToVariabledefinition         |
| tbl_lnkServicedependencyToHost_DH          |
| tbl_lnkServicedependencyToHost_H           |
| tbl_lnkServicedependencyToHostgroup_DH     |
| tbl_lnkServicedependencyToHostgroup_H      |
| tbl_lnkServicedependencyToService_DS       |
| tbl_lnkServicedependencyToService_S        |
| tbl_lnkServiceescalationToContact          |
| tbl_lnkServiceescalationToContactgroup     |
| tbl_lnkServiceescalationToHost             |
| tbl_lnkServiceescalationToHostgroup        |
| tbl_lnkServiceescalationToService          |
| tbl_lnkServicegroupToService               |
| tbl_lnkServicegroupToServicegroup          |
| tbl_lnkServicetemplateToContact            |
| tbl_lnkServicetemplateToContactgroup       |
| tbl_lnkServicetemplateToHost               |
| tbl_lnkServicetemplateToHostgroup          |
| tbl_lnkServicetemplateToServicegroup       |
| tbl_lnkServicetemplateToServicetemplate    |
| tbl_lnkServicetemplateToVariabledefinition |
| tbl_lnkTimeperiodToTimeperiod              |
| tbl_logbook                                |
| tbl_mainmenu                               |
| tbl_service                                |
| tbl_servicedependency                      |
| tbl_serviceescalation                      |
| tbl_serviceextinfo                         |
| tbl_servicegroup                           |
| tbl_servicetemplate                        |
| tbl_settings                               |
| tbl_submenu                                |
| tbl_timedefinition                         |
| tbl_timeperiod                             |
| tbl_user                                   |
| tbl_variabledefinition

Re: Nagios - distributed environment

Posted: Mon Jan 20, 2014 3:54 am
by MSPk
Do we need to configure the Modgearman server in the initial stage when the Nagios server is build or can it be configured at any point of time?

Also, Can we off load RRD's as well?

Re: Nagios - distributed environment

Posted: Mon Jan 20, 2014 11:12 am
by slansing
It can be done at any point, I'd recommend taking a look at rrd cached. Mod gearman will offload check and performance data processing, so there is not really a need to offload RRDs themselves.. but RRD cached can help performance in some cases:

http://assets.nagios.com/downloads/nagi ... ios_XI.pdf

Re: Nagios - distributed environment

Posted: Thu Jan 23, 2014 11:53 am
by MSPk
from the image below, do we need to have the mod-gearman worker on both nagios xi instance and on the second server to distribute the load between both the servers.

[img]
mod-gearman.png
[/img]

Re: Nagios - distributed environment

Posted: Thu Jan 23, 2014 12:30 pm
by slansing
You can set it up which ever way you want, you can run the workers locally, or set the worker daemon up on a remote system. Then you can push check and perfdata processing from your servers to those remote workers, etc. It is quite flexible.

Re: Nagios - distributed environment

Posted: Fri Jan 31, 2014 3:25 am
by MSPk
Hi team,

We are planning to offload the DB as speciified in the previous thread, we are now trying to understnad if the Database that was created during the Nagios XI installation can now be removed? If yes, How? If No, what purpose will this DB serve?

Re: Nagios - distributed environment

Posted: Fri Jan 31, 2014 12:35 pm
by sreinhardt
You can offload the mysql database, but not the postgresdb. Here is the documentation referencing offloading mysql. Please note that you cannot have one mysql server share several XI databases, and several XI instances, cannot share one database.

http://assets.nagios.com/downloads/nagi ... Server.pdf

Re: Nagios - distributed environment

Posted: Mon Feb 03, 2014 5:26 am
by MSPk
Hi Team,

Please suggest what data/tables are stored in postgres db?

Re: Nagios - distributed environment

Posted: Mon Feb 03, 2014 1:28 pm
by abrist
Postgres is only used for XI specific data. Mostly XI users, and their personal settings, as wells as system wide settings like the external url and phmailer settings.
All times are UTC-05:00
Page 2 of 3

Powered by phpBB® Forum Software © phpBB Limited