awesome-mysql

A curated list of awesome MySQL free and opensource software, libraries and resources.

This list accepts and encourages pull requests. See CONTRIBUTING

Contents

• Awesome MySQL

  • Analysis
  • Backup
  • Benchmarking
  • Binlog Replication
  • ChatOps
  • Configuration
  • Connectors
  • Deployment
  • Development
  • GUI
  • HA
  • MCP
  • Proxy
  • Replication
  • Schema
  • Security
  • Server
  • Sharding
  • Toolkits

• Resources

  • E-Books
  • Media
  • Newsletters

Analysis

Performance, structure & data analysis tools

• Anemometer - Box SQL slow query monitor.
• innodb-ruby - A parser for InnoDB file formats, in Ruby.
• innotop - a 'top' clone for MySQL with many features and flexibility.
• MySQL Explain Analyzer - A web-based analyzer of EXPLAIN FORMAT=JSON output, providing comments, scalability analysis and permalinks for saved samples.
• mysql-statsd - A Python daemon to collect information from MySQL and send it via StatsD to Graphite.
• MySQLTuner-perl - A script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
• Prometheus/mysqld_exporter - Time series database for real-time monitoring and alerting.
• pstop - a top-like program for MySQL, collecting, aggregating and displaying information from performance_schema.
• Wireshark - a protocol analyzer that can decode the MySQL protocol.
• Dolphie - a modern terminal tool for real-time analytics into MySQL/MariaDB & ProxySQL

Backup

Backup/restore/recovery tools

• Dumpling - Logical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
• MyDumper - Logical, parallel backup/dumper tool for MySQL
• Percona Xtrabackup - an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup.

Benchmarking

Tools to stress your servers

• go-tpc - A golang port of TPCC and TPCH benchmark for MySQL.
• iibench-mysql - Java based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB.
• Sysbench - a modular, cross-platform and multi-threaded benchmark tool.
• TPCC-MySQL (archived) - A port of the popular TPCC benchmark for MySQL.

Binlog-Replication

• DM - A High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
• Kingbus - A distributed MySQL binlog storage system built on Raft
• mysql-ripple (archived) - Ripple, a server that can serve as a middleman in MySQL replication

ChatOps

Scripts integrated into chat rooms

• Hubot MySQL ChatOps

Configuration

MySQL sample configuration and advisors

• mysql-compatibility-config - make MySQL configuration behave more like newer (or older) releases of MySQL.

Connectors

MySQL connectors for various programming languages

• ballerinax/mysql - Official Ballerina connector for MySQL.
• DBD::MariaDB - MariaDB and MySQL driver for the Perl5 Database Interface.
• DBD::mysql - MySQL driver for the Perl5 Database Interface.
• go-sql-driver - a lightweight and fast MySQL-Driver for Go's (golang) database/sql package.
• libAttachSQL - libAttachSQL is a lightweight, non-blocking C API for MySQL servers.