MySQL tool Summary

This article summarizes all the tools related to MySQL O & M development and will be continuously updated.

1. Toolkit set

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

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

Ps-helper (performance schema toolset): 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

Admin: 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 Testing Tool

Sysbench:

Tpcc-mysql:

Dbt2:

Data generator

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

Geographic 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/