The Monolith Toolkit of scripts for DBA routines. 0.4.3 has been released. You can download it here: http://code.google.com/p/monolith-toolkit/
Some information on the toolkit and what it contains:
- mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features
- mt-check-replication -> script to report on replication status for slave servers
- mt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering)
- mt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on
- mt-connections-log -> logs connections to mysql to disk, reports on threshold overages
- mt-flush-tables-sequence -> runs through schema.tables to flush in sequence before global flush
- mt-rotate-logs -> rotates general and slow query logs on periodic basis
- mt-my.cnf_xG -> MySQL configuration file for a particular RAM size installation
Changes for this release:
- Fixed the cnf files error that specified G instead of M for tmp table size and max_heap_table_size.
- Fixed the parallel backup script pruning command. Uses system rm instead of UNLINK.
- Fixed the default number of forks to create for parallel backup so we don’t overload the server.
