kontrollkit

A collection of DBA-centric scripts written in shell and perl script.

 Download Kontrollkit now

  • kt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features
  • kt-backup-ai -> runs mysql backups standard mysqldump method but adds nice features like email reporting and backup completion checking as well as compression, also adds disk space checking and size analysis before running the backup to ensure you don’t use up 100% partition space with a backup.
  • 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 -> generates a report for point-in-time system status that is useful for troubleshooting MySQL servers.
  • kt-url-monitor -> monitors a given URL for successful return code. Has email functionality for reporting.