New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[dev.icinga.com #8756] Improve DB IDO config dump performance #2767
Comments
Updated by TheSerapher on 2015-03-16 12:30:41 +00:00 Here the WorkQueue during Master Startup. Once startup completes, this queue stays empty until checkers are added.
|
Updated by TheSerapher on 2015-03-16 12:49:02 +00:00 It seems that during reload the IDO connections are paused too:
If that is the case, the master would probably stop updating the status table until the reload completes? |
Updated by mfriedrich on 2015-03-19 09:41:11 +00:00
|
Updated by TheSerapher on 2015-04-17 10:39:54 +00:00 Here an idea that could help to speed up cluster restarts if no config changes are required: Maybe store an overall configuration of checks MD5 sum in the database, once the master starts it can check against the current md5 sum of the current configuration and compare with what is on file in the DB. If those match, just start up and don't dump the configuration. Would greatly improve restarting the core for Icinga2 changes that do not involve any check changes. As for check updates, a proper way to improve performance is still required. |
Updated by gbeutner on 2015-12-10 16:18:52 +00:00
|
Updated by mfriedrich on 2016-04-07 09:20:00 +00:00
|
Updated by mfriedrich on 2016-04-07 09:20:51 +00:00
|
Updated by mfriedrich on 2016-04-07 09:22:28 +00:00
|
Updated by gbeutner on 2016-08-15 10:56:54 +00:00
|
Updated by gbeutner on 2016-08-15 10:57:36 +00:00 This will likely be addressed by #12435. |
Updated by gbeutner on 2016-08-15 14:51:27 +00:00
Please re-test this with the latest master branch. Note that the initial config dump might take longer than before - but subsequent restarts should be noticibly faster. |
Updated by mfriedrich on 2016-09-30 13:54:03 +00:00 Please test that with 2.5.4 and provide your findings. Otherwise we'll close the issue soon-ish. |
Updated by mfriedrich on 2016-11-11 08:46:16 +00:00
|
Updated by mfriedrich on 2016-11-11 08:47:01 +00:00
|
This issue has been migrated from Redmine: https://dev.icinga.com/issues/8756
Created by TheSerapher on 2015-03-16 08:34:17 +00:00
Assignee: TheSerapher
Status: Closed (closed on 2016-11-11 08:46:16 +00:00)
Target Version: (none)
Last Update: 2016-11-11 08:47:01 +00:00 (in Redmine)
We have been seeing issues with the initial configuration dump during server startups taking a very long time to complete a full wipe and re-fill of all tables. This interferes with masters when doing reload causing them to initiate a failover. It would be great if these dumps could somehow be changed to only update the tables when needed. Maybe a simple first step could be a config md5sum stored in a table that can be compared against, that way not every restart or reload causes this. Or go further and keep a sum over all files that have been loaded into DB and only reload those files, that have changed.
I don't know the inner workings of Icinga2 so I am not sure this is even doable, but it would greatly help in startup performance.
Relations:
The text was updated successfully, but these errors were encountered: