balazspocze.me

General blog

Projects

MySQL backend checker

MySQL backend checker. This tool is designed to run queries against a MySQL database and based on their results, report HTTP/200 or HTTP/500 which could be monitored from a HAProxy instance and route traffic to the host which is ‘available’ in a given time.

MySQL statsd sender

MySQL -> statsd proxy. The tool run queries against the database and send their results to a  statsd server.

MySQL binlog streamer utility

This tool runs ‘mysqlbinlog’ utility to stream binlogs from a remote MySQL server to a local directory – and if configured that way – handles the expiration of those logs. It is aware to find the last log file which is not completely synced, and start streaming from that file.

Utilities

A bunch of bulk stored utilites which are not interesting enough to put them into separate repositories.

  • monitor_space – this utility is able to keep track of your database table size changes. It reads data from file system, not from information_schema, so you can’t use it on RDS. (PR’s accepted.) I posted about this earlier.
  • binlog_extractor.awk – when you use GTID replication, and you want to create a point-in-time recovery from binlogs. Knowing the last GTID executed, this help which position to load.
  • check_mysql_connections.sh – this is nothing actually. You can put it to your .profile as a function and you can spare writing a few characters every time you want to check which servers connected to MySQL – regarding to netstat
  • checkconn.pl – helps to check how much connections you have on a server, and you can break them down by server, by database or by user.
  • checkfrag.pl – with this you can check how fragmented your tables in mysql. This checks the file size on disk – sorry, no RDS – and then in the data dictionary. After that gives you a list of the tables, and hints you which tables should be rebuilt to free up space. The tool is not precise, but hints good.
  • rds_node_selector.sh – needs dialog, and awscli configured. Queries AWS API to get your RDS server lists, and provides a neat interface to connect to them.