Everday utilities for sysadmin stuff.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
monitor_space
playback-based
README.md
binlog_extractor.awk
check_mysql_connections.sh
checkconn.pl
checkfrag.pl
rds_node_selector.sh

README.md

Utilities

Everday utilities for sysadmin stuff. Mostly for MySQL.

  • check_mysql_connections.sh
    • can run on any server, and filters the netcat output to check where is connected with mysql
  • checkconn.pl
    • queries the information_schema.processlist table, to show who is connected to database
  • checkfrag.pl
    • queries the information_schema.tables table, compares the table sizes of the sizes used on disk
  • monitor_space
    • Monitors space changes on mysql server
      • monitor_space_collector.pl - collects data about table sizes
      • monitor_space_qt.pl - Query tool for monitor space
  • binlog_extractor.awk
    • You have to give it a GTID and it will return the next position from an SQL dump of MySQL binlog
  • rds_node_selector.sh
    • fancy menu based terminal tool for connecting your rds instances. It queries the aws api for your hosts. When you use the --iddqd switch it can connect to writer nodes, if not, just the readers are available (if an aurora cluster has only 1 node it could be writed as well. You need configured awscli, .my.cnf and dialog installed