OmniSQL (a command line tool for DBAs needing to issue ad-hoc queries against sharded data) version 0.0.7 is officially released. Instead of logging in separately to multiple databases to issue the same query, groups of databases can be specified in a configuration file and queries will be automatically issued against all targeted MySQL instances. Let me know [...]

A lot of my clients are in a position where their database performance is deteriorating but they are not “big enough” (or not willing/able to) explore sharding all of their data structures. They’re too big for the solution to be adding another read slave, but too small to justify the resources for re-designing their [...]

OmniSQL (a command line tool for DBAs needing to issue ad-hoc queries against sharded data) version 0.0.6 is officially released. Instead of logging in separately to multiple databases to issue the same query, groups of databases can be specified in a configuration file and queries will be automatically issued against all targeted MySQL instances. [...]

OmniMySQL 0.0.4 is a minor release fixing two bugs that I should have caught (it now crashes less). The current release can be downloaded here.

This release fixes bugs and changes the parser from SQL::Parser to DBIx::MyParsePP. This change was made in order to accommodate MySQL-specific deviations from Standard SQL. Unfortunately, this change also comes with the expense of a slow startup, but I think it is worth the trade-off. OmniMySQL can be downloaded here. CHANGELOG: 0.0.3 - 15 [...]