Show Hosts Connected to MySQL

| Comments

For the terminal jockies, this is a quick and dirty for finding who, or what, is connected to your server. This proves useful when you’re running in tmux and want a pane for tracking what is left to disconnect from your database before shutting it down.

Pulling a Large MySQL Table Into Elasticsearch

| Comments

If you need to perform realtime queries against a huge MySQL table, but are no longer able to due to the size of the table, read on to find out how to make elasticsearch do the heavy lifting for you!

This solution includes the ability to perform regular updates to elasticsearch of new data that gets pushed to the table in MySQL.