Posts in category Monolith
Daily growth expectations for Kontrol...
Data storage requirements for Kontrollbase [monolith] server_statistics + server_report tables. These are the tables that accept incoming data from the polling processes. They hold the historical data for each server that’s being monitored.
AVG Per Server
Assuming stats every 10 minutes = 144/day
Assuming reports every hour = 24/day
1 [...]
On the reporting engine, and a new na...
Update for all of those that are following the progress of Monolith. I’ve been busy this week coding the reporting engine – the code that analyses the hundreds of variables that are being collected – and I’m pleased to say that Perl was the correct choice for this application.Installation on the client servers will b [...]
Seeking volunteer test machines for M...
Monolith: MySQL server monitoring. I only have servers that run Redhat/Debian/Ubuntu Linux x86 and x86_64. I don’t have machines to test MySQL monitoring for the following OSes. Perhaps you would like to be a test candidate for the new version of Monolith? If so, let me know and you’ll be on the list, as well as get beta testing [...]
Update: OSS MySQL Monitoring Solution
Progress on the Open Source enterprise grade MySQL monitoring system; the schema for Monolith version 2 has been designed. Due to the many suggestions for features and the interest it has received I’ve put this on the front burner. That said, here is some more info on the next steps I’ll be taking.
Monitored servers will use a [...]
Request: What do you want in a OpenSo...
What would you like to see in a free enterprise-grade monitoring system for your daily MySQL needs?I’m rewriting Monolith – MySQL DBA Console from the ground up. This will be version 2 and I would like to get some input from the global MySQL community.So far I am going with the following; comment with any improvements/additions. [...]
Parallel mysqldump backup script avai...
Large databases, long mysqldump times, long waits for globally locked tables. These problems basically never go away when you rely on mysqldump with –all-databases or a list of databases, as it dumps schemas serially. I’m not going to explain serial vs parallel processing here since that’s a larger topic. Suffice to say th [...]
Monolith – MySQL DBA Console 1....
Big changes in this release.
Features:
Talkback report for local script backups to report back to monolith console
Status page now summarizes all Codes and failed server connections for past 24 hours
Install now has correct data import for user setup and system settings
More GRAPHS!
Improved logic for analytics and automated tuning recomme [...]
Monolith gets max/avg graphs
Updated some code to graph out the max/avg numbers for Query rate, Data growth, and Connections. Images below.
Monolith 1.3 soon to be released
New features for the next release. As follows:
Status page now reports daily error code summarizations, connection failures to hosts
Talkback report page now reports on myback_talkback script version number
Talkback report page now tracks the my.cnf file during the backup process, and the cnf file contents for each host are stored as LONGT [...]
New VIEW tables for Monolith 1.2 Repo...
Here are some view tables that are going to be in the new release of Monolith. They work with the current release though, so maybe they will be useful for DBAs that have utilized the CLI to get data out of Monolith. The new release will feature an updated Status page that shows the data from these view tables instead of the “last 25 b [...]
