google / Mysql Tools

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
  • Depends on tlslite.
• 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/