Monday, April 04, 2011

MySQL tools released by Google

Various tools for managing, maintaining, and improving the performance of MySQL databases, originally written by Google.

Libraries:
pylib/db.py: Easily execute queries in parallel on a sharded database
Depends on MySQLdb. Most tools here depend on it.
permissions_lib/: Manage MySQL permissions in a Python-based format
parser_lib/: Parse SQL and apply rules based on the parsed output
Depends on pyparsing.

Binaries:
sql.py: Interactive shell for pylib/db.py
permissions.py: Tool for pushing permissions to servers using permissions_lib/
validate.py: Tool for validating SQL using parser_lib/

Read more: Google code