Hi Michael! We have 1700 Hosts and 14600 Services. I will analize the Performance of the database, many thanks for your answer :)
Regards, Christian Christian Moreno Moreno System Engineer Offers idealo internet GmbHRitterstraße 11 10969 Berlin, DeutschlandTel.: +49 (0)30 40 30 10 33Fax: +49 (0)30 221 94 33 - 21E-Mail: christian.moreno@idealo.deGeschäftsführer:Dr. Albrecht von Sonntag, Dr. Philipp-Christopher PeitschHRB 76749 – Amtsgericht Berlin-Charlottenburg[image: idealo Logo] <http://www.idealo.de/> 2015-08-20 12:00 GMT+02:00 <icinga-users-requ...@lists.icinga.org>: > Send icinga-users mailing list submissions to > icinga-users@lists.icinga.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.icinga.org/mailman/listinfo/icinga-users > or, via email, send a message with subject or body 'help' to > icinga-users-requ...@lists.icinga.org > > You can reach the person managing the list at > icinga-users-ow...@lists.icinga.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of icinga-users digest..." > > > Today's Topics: > > 1. Re: Problems with Icingaweb2 and Postgresql (Michael Friedrich) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 20 Aug 2015 11:36:27 +0200 > From: Michael Friedrich <michael.friedr...@netways.de> > To: <icinga-users@lists.icinga.org> > Subject: Re: [icinga-users] Problems with Icingaweb2 and Postgresql > Message-ID: <55d59f9b.5060...@netways.de> > Content-Type: text/plain; charset="utf-8"; Format="flowed" > > Am 20.08.2015 um 11:24 schrieb Christian Moreno Moreno: > Hi All, > > We use Icinga2 with icingaweb2: > > Icinga2: Two nodes (cluster) and every node with the module ido-pgsql. > Icingaweb2: With two Backends in PGSQL(Backend IcingaDB and Backend > IcingawebDB) > Database: PGSQL > > Version: > Icinga2: 2.3.8-1~debmon70+1 > icingaweb2: 2.0.0~rc1-1~debmon70+1 > Postgresql: 9.4.1-1.pgdg70+1 > > All runs correctly, but every time that we do one reload/restart of > icinga2 then we have for some minutes the next Problems with Icingaweb2: > - Alarm "Backend Down" > - We cant see the Hostgroups, Downtimes, and some Custom variables. > > After some minutes, then all looks one more time good. > > I saw with "Icinga Cluster Check" that after one reload/restart, PGSQL get > a lot of more queries "idopgsqlconnection_pgsql-ido_query_queue_items" > (sometime sometimes until 250-300K, normally it has any or only 20-30). > > I'd say your database backend cannot deal with the amount of updates > (config and status queries), and performs poorly. I would analyze your > database performance and identify bottlenecks over there. Icinga Web 2 is > just the reading application, you may simulate its queries directly on the > shell as well. > > How many objects are configured in this setup? > > Kind regards, > Michael > > > Is this one Bug or I do something wrong? I have the feeling that PGSQL is > blocked for icingaweb2 until that the queries go down. > Wath type of rights needs icingaweb2's user for the Icinga2 DB? Are > sufficient read rights? I was thinking about use one of the Postgresql > Slave for the icinga2 Backend. > > Best Regards, > Christian > > > Christian Moreno Moreno > System Engineer Offers > > > > idealo internet GmbH > Ritterstra?e 11 > > 10969 Berlin, Deutschland > Tel.: +49 (0)30 40 30 10 33 > Fax: +49 (0)30 221 94 33<tel:%2B49%20%280%2930%20221%2094%2033> - 21 > E-Mail: <mailto:christian.mor...@idealo.de> christian.mor...@idealo.de > <mailto:christian.mor...@idealo.de> > Gesch?ftsf?hrer: > Dr. Albrecht von Sonntag, Dr. Philipp-Christopher Peitsch > HRB 76749 ? Amtsgericht Berlin-Charlottenburg > [idealo Logo]< > http://www.idealo.de/> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org<mailto:icinga-users@lists.icinga.org> > https://lists.icinga.org/mailman/listinfo/icinga-users > > > > --? > Michael Friedrich, DI (FH) > Application Developer > > NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg > Tel: +49 911 92885-0 | Fax: +49 911 92885-77 > GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 > http://www.netways.de | michael.friedr...@netways.de > > ** OSBConf 2015 - September - osbconf.org ** > ** OSMC 2015 - November - netways.de/osmc ** > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.icinga.org/pipermail/icinga-users/attachments/20150820/ab925fd4/attachment-0001.html > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org > https://lists.icinga.org/mailman/listinfo/icinga-users > > > ------------------------------ > > End of icinga-users Digest, Vol 20, Issue 29 > ******************************************** >
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
