• MySQL工具汇总


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

    慢日志分析工具:
    mysqldumpslow  MySQL自带的
    mysqlsla  http://hackmysql.com/scripts/
    pt-query-digest  percona-toolkit工具包里面的

    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 实时状态分析
    mysqlmon:http://pan.baidu.com/s/1mgJpukg?qq-pf-to=pcqq.group#dir/path=%252FOneSQL%252FTools
    innotop:https://code.google.com/p/innotop/
    orzdba:http://code.taobao.org/p/orzdba/src/trunk/orzdba
    mytop:http://jeremy.zawodny.com/mysql/mytop/
    MySQL administrator:Mysql公司发布管理工具
     
    3. mysql客户端&开发工具
    Adminer:http://www.adminer.org/ 
    MyQuery:http://sourceforge.net/projects/myquery/
    Hopper(存储过程调试工具):http://www.upscene.com/products.hopper.index.php
     
    4. MySQL性能监控
    mycheckpoint:http://code.google.com/p/mycheckpoint/downloads/list
    mysql-statsd:https://github.com/spilgames/mysql-statsd 
    nethogs: http://www.oschina.net/p/nethogs/ 
    Nagios:http://www.nagios.org/download
    zabbix:http://www.zabbix.com/download.php
    MySQL Enterprise Monitor:mysql企业监控
     
    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/

    版权声明:QQ:597507041

  • 相关阅读:
    ORA-65114
    Mariadb 10.14 mysqldump error: 1049
    nginx:403 forbidden
    ORA-01017
    oracle 12C 之 Clone 数据库
    Selinux的基本使用
    This system is not registered to Red Hat Subscription Management
    Emacs: too long for unix domain socket
    hive 之 元数据表结构(Mysql)
    hive之SerDe
  • 原文地址:https://www.cnblogs.com/spzhangfei/p/4801751.html
Copyright © 2020-2023  润新知