> On 26 Jan 2016, at 11:49, Martin Stiborský <martin.stibor...@gmail.com> wrote: > > Hello, > some time ago I've been asking here for some details about implementing HA > for Icinga2 master server. > I need two master servers, one is located in Europe, the second one in US. > The concern I have is the database server, I'd really like to have dedicated > database server for both master server geographical location. > So I did, I habe two DB servers and these two are configured for > master-master replication. > That works. Now, how Icinga handle that? > > When I configured each Icinga2 instance to use its database server, I > immediatelly got "duplicate items" error and deadlocks.
Basically because both sides try to write the same amount of exchanged config objects and events to the local database, which then replicates them again in their application cluster. That is not gonna work. > Now I have restored the database and pointed both icinga masters to the same > database, but everything is now doubled, checks, hosts…oops, that's different > problem I guess. Pointing both instances to the very same database connection requires enabling the HA setting for the DB IDO feature (which is the default if not explicitly set to enable_ha = false inside the config). This will ensure that only one node actives the IDO feature writing to the backend while the other node will only take over if the current active node dies, or cannot keep up. > > So, my question is, is there anybody with similar scenario? The icinga > database replicated? > What the "instane_name" from IdoMySqlConnection object does? > http://docs.icinga.org/icinga2/latest/doc/module/icinga2/toc#!/icinga2/latest/doc/module/icinga2/chapter/object-types#objecttype-idomysqlconnection That’s inherited from the old world where multiple instances where writing to the same database. The primary issue with that is data duplication, but probably a workaround for your problem. Keep in mind that interfaces not capable to grouping by instance_id will show the duplicated data like it is read from the backend. Kind regards, Michael > > Any hints, please? > > Thanks for help! > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org > https://lists.icinga.org/mailman/listinfo/icinga-users -- Michael Friedrich, DI (FH) Senior Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 CEO: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | michael.friedr...@netways.de ** OSDC 2016 - April - netways.de/osdc ** ** OSBConf 2016 - September - osbconf.org ** _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
