MySQL工具汇总

本文汇总了和MySQL运维开发相关的所有工具,并会持续更新

1. 工具套件集

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

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

ps-helper(performance schema 工具函数集):https://github.com/MarkLeith/dbahelper

2. MySQL 实时状态分析

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客户端&开发工具

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

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

Hopper(存储过程调试工具):http://www.upscene.com/products.hopper.index.php

4. MySQL性能监控

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

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

5. MySQL性能测试工具

sysbench:

tpcc-mysql:

dbt2:

data generator

测试数据生成:http://www.generatedata.com/

地理数据生成:http://www.openstreetmap.org/

6:数据路由中间件

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. 数据库版本管理

http://www.liquibase.org/

原文地址:https://www.cnblogs.com/joeylee/p/3897923.html