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 many reporting features and compression
    • kt-backup-simple -> runs mysql backups serially, includes reporting features and compression
    • 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