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 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.
These details are provided for information only. No information here is legal advice and should not be used as such.