Monolith DBA Toolkit 0.4.3 Released

2008/12/17 by admin in Backups, Monolith Toolkit, Scripts | Leave a comment

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.
Read More

Updated: Monolith Toolkit – MySQL DBA tools 0.4.2

2008/10/14 by admin in Monolith Toolkit | Leave a comment

Updated the release, sure it’s only been a matter of hours but I added the standard cnf files for 2,4,8 and 16GB server installations. Also added the rhcluster-wrapper script that can be used to run just about anything on the active database node when using mysql in an active/passive setup.

Download here:  http://code.google.com/p/monolith-toolkit/

Read More

Monolith Toolkit – MySQL DBA tools released!

2008/10/14 by admin in Monolith Toolkit, Scripts | Leave a comment

Today I decided to package all of my various scripts together into a useful toolkit. Some are perl, some are shell script. These scripts are, in general, one off scripts that I wrote in order to get things done that weren’t available at the time. Now they’re nicely organized and will receive updates at the google code repo.

So far the toolkit includes the following scripts:

  • mt-backup-parallel -> the parallel backup script I wrote about in my last post
  • mt-check-replication -> script to report on replication status for slave servers
  • mt-check-rhcluster-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering)
  • 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

To download go here: http://code.google.com/p/monolith-toolkit/

Note: these are not associated (yet) with the main Monolith project that is for monitoring. Although it will be soon :)

Read More