MySQL Tools summary

This article summarizes all of the tools associated with MySQL DevOps development and will continue to update

1. Tool Suite Set

Percona-toolkit:http://www.percona.com/software/percona-toolkit

Oak-toolkit:http://code.openark.org/forge/openark-kit

Ps-helper (Performance schema Tool function set): Https://github.com/MarkLeith/dbahelper

2. MySQL Real-time status analysis

innotop:https://code.google.com/p/innotop/

Orzdba:http://code.taobao.org/p/orzdba/src/trunk/orzdba

mytop:http://jeremy.zawodny.com/mysql/mytop/

3. mysql Client & Development tools

adminer:http://www.adminer.org/

myquery:http://sourceforge.net/projects/myquery/

Hopper (Stored procedure Debugging tool): http://www.upscene.com/products.hopper.index.php

4. mysql Performance monitoring

Mysql-statsd:https://github.com/spilgames/mysql-statsd

nethogs:http://www.oschina.net/p/nethogs/

5. mysql Performance test tool

Sysbench:

Tpcc-mysql:

DBT2:

Data generator

Test data generation: http://www.generatedata.com/

Geo-data generation: http://www.openstreetmap.org/

6: Data Routing middleware

mysql-proxy:http://dev.mysql.com/downloads/mysql-proxy/

Atlas:https://github.com/qihoo360/atlas

mycat:https://code.google.com/p/opencloudb/

Maxscale:https://github.com/skysql/maxscale

GLB:

scalearc:http://www.scalearc.com/

7. Database Version Management

http://www.liquibase.org/