I'm happy to announce a new round of Google MySQL tool releases. We're just getting started, but here's what's available so far:
db.py: Easily execute queries in parallel on a sharded database
sql.py: Interactive shell to db.py
permissions.py: Manage MySQL permissions in a Python-based format
validate.py: Parse SQL using pyparsing and apply rules with live DB data
These are the actual tools being used to run MySQL at scale inside
Google, not one-time sanitized copies. You can get them at
http://code.google.com/p/google-mysql-tools/. 转自:http://jackyrong.iteye.com/blog/986291