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: [email protected]ä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 <[email protected]>: > Send icinga-users mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: <[email protected]> > Subject: Re: [icinga-users] Problems with Icingaweb2 and Postgresql > Message-ID: <[email protected]> > 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:[email protected]> [email protected] > <mailto:[email protected]> > 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 > [email protected]<mailto:[email protected]> > 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 | [email protected] > > ** 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 > [email protected] > https://lists.icinga.org/mailman/listinfo/icinga-users > > > ------------------------------ > > End of icinga-users Digest, Vol 20, Issue 29 > ******************************************** >
_______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
