opensource-db-tools - A set of open source tools for MySQL

You need to install and run the Gearman job server first. Instructions to install gearman on Debian Linux can be found here. Or, if you want to install Gearman on another platform, please check out Gearman's website for installation instructions.

Then, you need to download the source files or executables (if available for your platform). opensource-db-tools consists of two separate scripts for each tool ie. a worker and a client. All clients and workers are completely written in Python 2.7 (so far).

A client script submits jobs to Gearman job server (on behalf of users) for worker(s) to work on it. The all-schemas script depends on the following external modules (more will be added later):

• MySQLdb
• gearman
• daemon (http://www.clapper.org/software/python/daemon/)

You can run as many workers (but be careful) as you want to achieve faster response times through Gearman’s multiprocessing capability.

Project

The project currently resides on Google code and the URL is http://code.google.com/p/opensource-db-tools/.

Download

There are no executables available right now but you can download the source files and run them using Python. Click here to see the source files for all-schemas tool that is the first one in the project.

Bugs

If you happen to find any bugs in the project, please feel free to create an issue in the issue tracker here.

Did this tutorial help a little? How about buy me a cup of coffee?

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I recommend thoroughy testing on a production-like test system first before moving to production.

nice article Posted by: Shahryar on Nov 15, 2010

Name
Email address
Website
Comments
	Notify me of follow-up comments via email.

Similar Tutorials:

• MySQL DATE_FORMAT function and ORDER BY
• MySQL open files limit: open-files-limit VS open_files_limit on Linux
• Not-so-well-known differences between MyISAM and Innodb MySQL server storage engines
• MySQL Query Cache not necessarily a bad thing
• How to find if MySQL supports partitioning or not?

Tutorials in 'Database Management Systems > MySQL' (more):

• How to set default values for MySQL JSON columns
• How to delete rows in table when PK is referenced in another table
• Unique primary keys(PKs) for MySQL using Redis
• How to rename MySQL DB by moving tables
• How to set innodb_flush_log_at_timeout in MySQL 5.6?

Recent Tutorials:

• How to set default values for MySQL JSON columns
• How to delete rows in table when PK is referenced in another table
• Unique primary keys(PKs) for MySQL using Redis
• How to rename MySQL DB by moving tables
• How to compile and install Varnish-cache on Linux