GitHub - google/mysql-tools

This repository has been archived by the owner on Jul 13, 2022. It is now read-only.

Name		Name	Last commit message	Last commit date
Latest commit History 148 Commits
drift_lib		drift_lib
github/wiki/images		github/wiki/images
io_throttle		io_throttle
old/mysql-patches		old/mysql-patches
parser_lib		parser_lib
permissions_lib		permissions_lib
pylib		pylib
willie_lib		willie_lib
COPYING		COPYING
README		README
aggregate.py		aggregate.py
extract_slow_queries.py		extract_slow_queries.py
generate_checksums.py		generate_checksums.py
lint.py		lint.py
permissions-example.py		permissions-example.py
permissions.py		permissions.py
replication_heartbeat.py		replication_heartbeat.py
sql.py		sql.py
sql_batch.py		sql_batch.py
tablify.py		tablify.py
trickle_file_runner.py		trickle_file_runner.py
validate.py		validate.py
willie.py		willie.py

Repository files navigation

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/