Projects

kontrollkit

A collection of scripts for making your daily MySQL DBA responsibilities easier. Formerly known as Monolith Toolkit. kt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features kt-backup-simple -> runs mysql backups in standard mysqldump method but adds ... [More] nice features like email reporting and backup completion checking as well as compression. kt-backup-fast -> new backup script that (when finished) will replace the simple backup script. kt-check-replication -> script to report on replication status for slave servers kt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering) kt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on kt-connections-log -> logs connections to mysql to disk, reports on threshold overages kt-flush-tables-sequence -> runs through schema.tables to flush in sequence before global flush kt-rotate-logs -> rotates general and slow query logs on periodic basis kt-my.cnf_xG -> MySQL configuration file for a particular RAM size installation kt-daily-optimize -> analyzes and optimizes your tables kt-delete-via-datetime -> automated script that keeps tables pruned via a DATETIME column. kt-mysql-systemcheck_23 -> generates a report for point-in-time system status that is useful for troubleshooting MySQL servers. This is for systems running Python 2.3 or prior. kt-mysql-systemcheck_24 -> generates a report for point-in-time system status that is useful for troubleshooting MySQL servers. This is for systems running Python 2.4 or higher. kt-url-monitor -> monitors a given URL for successful return code. Has email functionality for reporting. [Less]