大量 MySQL 学习资源集合：awesome-mysql
n6bg
10年前
大量的MySQL软件，库，工具和资源。
分析
性能, 结束与数据分析工具
- 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.
- pstop - a top-like program for MySQL, collecting, aggregating and displaying information from performance_schema.
- mysql-statsd - A Python daemon to collect information from MySQL and send it via StatsD to Graphite.
备份
备份/恢复工具
- 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
- iibench-mysql - Java based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB.
- Sysbench - a modular, cross-platform and multi-threaded benchmark tool.
ChatOps
Scripts integrated into chat rooms
Connectors
MySQL connectors for various programming languages
- Connector/Python - a standardized database driver for Python platforms and development.
- 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.
- MariaDB Java Client - LGPL-licensed MariaDB Client Library for Java Applications.
- MySQL-Python - MySQL database connector for Python programming.
Deployment
MySQL deployment tools
- MySQL Sandbox - a tool that installs one or more MySQL servers within seconds, easily, securely, and with full control.
Development
Tools to support MySQL-related development
- Flywaydb - Database migrations; Evolve your database schema easily and reliably across all your instances
- Liquibase - Source control for your database
- Propagator - Centralized schema & data deployment on a multi-everything topology
GUI
GUI frontends & applications
- HeidiSQL - MySQL GUI frontend for Windows.
- MySQL Workbench - provides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration.
- phpMyAdmin - a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
- SequelPro - a Mac database management application for working with MySQL databases.
HA
High availability solutions
- Galera Cluster - a true Multimaster Cluster based on synchronous replication.
- MHA - Master High Availability Manager and tools for MySQL
- MySQL Fabric - an extensible framework for managing farms of MySQL Servers.
Proxy
Proxies to MySQL
- MaxScale - open-source, database-centric proxy.
- Mixer - a MySQL proxy powered by Go which aims to supply a simple solution for MySQL sharding.
- MySQL Proxy - A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication.
- ProxySQL - High performance proxy for MySQL.
Replication
Replication related software
- orchestrator - MySQL replication topology management and visualization tool.
- Tungsten Replicator - A high performance, open source, data replication engine for MySQL.
Schema
Add-on schemas
- common_schema - DBA's framework for MySQL, providing a function library, views library and QueryScript interpreter.
- sys - A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage.
Server
MySQL server flavors
- MariaDB - Community developed fork of MySQL server.
- MySQL Server & MySQL Cluster - Official Oracle's MySQL server & MySQL Cluster distribution.
- Percona Server - An enhanced, drop-in MySQL replacement.
- WebScaleSQL - WebScaleSQL, Version 5.6, based upon the MySQL-5.6 community releases.
Sharding
Sharding solutions/frameworks
- vitess - vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services.
- jetpants - An automation suite for managing large range sharding clusters, by Tumblr.
Toolkits
Toolkits, general purpose scripts
- go-mysql - A pure go library to handle MySQL network protocol and replication.
- Percona Toolkit - a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually.
- UnDROP - a tool to recover data from dropped or corrupted InnoDB tables.
Resources
At this stage "resources" will not include websites, blogs, slides, presentation videos, etc. in fear of list size
Conferences
Public, recurring conferences on and around MySQL
- FOSDEM - a free event for software developers to meet, share ideas and collaborate. Annually, in Brussels. Offers "MySQL & friends" room.
- MySQL Central - Oracle's annual MySQL conference, as part of Oracle Open World.
- Percona Live - MySQL & Openstack focused conference.
Media
Public, ongoing video & audio casts. This excludes conference presentations in fear of list size
- DBHangOps - a bi-weekly google hangout meeting of various members of the MySQL community that simply want to talk shop about MySQL in their day-to-day .
- OurSQL Podcast - The MySQL database community podcast.