Top 50 Awesome List

shlomi-noach/awesome-mysql

Databases  19 days ago  1.7k
A curated list of awesome MySQL software, libraries, tools and resources
View byDAY/WEEK/README
View on Github

Oct 6th

GUI

  • Sequel Acestars3.7k - a Mac database management application for working with MySQL databases.
  • Sep 15th, 2020

    e-books

  • Database Systems Lecture Notes - lecture notes on Database Systems (available in pdf, html, odt and markdown) including a Chapter on SQL that covers basic set-up, exercises and problems.
  • Jul 30th, 2020

    Backup

  • Dumplingstars237 - Logical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
  • Binlog-Replication

  • DMstars428 - A High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
  • Benchmarking

  • go-tpcstars84 - A golang port of TPCC and TPCH benchmark for MySQL.
  • Apr 30th, 2020

    Development

  • Skeema - Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
  • May 31st, 2019

    Development

  • Test databasestars2.8k - A sample MySQL database with an integrated test suite, used to test applications and servers
  • Apr 8th, 2019

    Binlog-Replication

  • Kingbusstars824 - A distributed MySQL binlog storage system built on Raft
  • mysql-ripplestars349 - Ripple, a server that can serve as a middleman in MySQL replication
  • Jan 26th, 2019

    Connectors

  • mex-mariadbstars1 - MIT licensed MariaDB/MySQL Client Library for GNU Octave and Matlab.
  • Dec 25th, 2018

    Analysis

  • MySQL Explain Analyzerstars60 - A web-based analyzer of EXPLAIN FORMAT=JSON output, providing comments, scalability analysis and permalinks for saved samples.
  • mysql-statsdstars99 - 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.
  • Percona Monitoring and Management - An open-source platform for managing and monitoring MySQL performance.
  • Prometheus/mysqld_exporterstars1.3k - Time series database for real-time monitoring and alerting.
  • pstopstars182 - a top-like program for MySQL, collecting, aggregating and displaying information from performance_schema.
  • Anemometerstars1.3k - Box SQL slow query monitor.
  • innodb-rubystars1.1k - A parser for InnoDB file formats, in Ruby.
  • innotopstars659 - a 'top' clone for MySQL with many features and flexibility.
  • Backup

  • MyDumperstars1.4k - Logical, parallel backup/dumper tool for MySQL
  • MySQLDumper - open-source web based backup tool - useful for shared webhosting
  • Percona Xtrabackup - an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup.
  • Configuration

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

  • Connector/C - Official C driver for MySQL.
  • Connector/CPP - Official C++ driver for MySQL.
  • Connector/J - a standardized database driver for the Java platforms and development.
  • Connector/Net - a standardized database driver for .Net platforms and development.
  • Connector/Node.js - Official Node.js driver for MySQL.
  • DBD::mysql - MySQL driver for the Perl5 Database Interface.
  • libAttachSQLstars34 - libAttachSQL is a lightweight, non-blocking C API for MySQL servers.
  • MariaDB Java Client - LGPL-licensed MariaDB Client Library for Java Applications.
  • mysqlclient-pythonstars2k - (Old) MySQL database connector for Python.
  • node-mysqlstars16.8k - A pure Nodejs Javascript client implementing the MySQL protocol.
  • PHP mysqlnd - MySQL native driver for MySQL, deprecating older libmysql based driver.
  • PyMySQLstars6.7k - MySQL database connector for Python.
  • Ruby Mysql2 gemstars2.1k - MySQL driver for Ruby and Rails projects.
  • Connector/Python - a standardized database driver for Python platforms and development.
  • go-sql-driverstars11.6k - a lightweight and fast MySQL-Driver for Go's (golang) database/sql package.
  • Deployment

  • MySQL Docker - Official Docker images.
  • dbdeployer - A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control.
  • Development

  • Shiftstars707 - An application that helps you run schema migrations on MySQL databases
  • Flywaydb - Database migrations; Evolve your database schema easily and reliably across all your instances
  • Liquibase - Source control for your database
  • GUI

  • Adminer - Database management in a single PHP file.
  • myclistars9.9k - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
  • MySQL Shell - Advanced client and code editor for MySQL that supports development and administration for the MySQL Server and MySQL InnoDB cluster (AdminAPI) with an interactive JavaScript, Python, or SQL interface.
  • Ocelot GUIstars52 - GUI client for MySQL or MariaDB, including debugger.
  • Percona Monitoring and Management - An open-source platform for managing and monitoring MySQL performance.
  • phpMyAdmin - a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
  • pspgstars1.7k - provides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL.
  • SQLyog Community edition - SQLyog Community edition. For Windows, works fine under wine in Mac and Linux
  • DBeaverstars22.8k - A cross-platform SQL and NoSQL database client.
  • HeidiSQL - MySQL GUI frontend for Windows.
  • MySQL Workbench - provides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration.
  • HA

  • MHA - Master High Availability Manager and tools for MySQL.
  • orchestratorstars4.3k - MySQL replication topology management and High Availability solution.
  • Percona Replication Managerstars77 - Asynchronous MySQL replication manager agent for Pacemaker. Supports file and GTID based replication, geo-distributed clusters using booth.
  • replication-managerstars492 - a high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies.
  • Galera Cluster - a true Multimaster Cluster based on synchronous replication.
  • Proxy

  • MySQL Router - MySQL Router is part of InnoDB cluster, and is a lightweight middleware that provides transparent routing between your application and back-end MySQL Servers.
  • MaxScalestars1.1k - open-source, database-centric proxy.
  • Mixerstars715 - 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.
  • ProxySQLstars22 - High performance proxy for MySQL.
  • Schema

  • common_schemastars111 - DBA's framework for MySQL, providing a function library, views library and QueryScript interpreter.
  • sysstars775 - A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage.
  • Security

  • Acrastars808 - SQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system.
  • Server

  • TiDBstars29.3k - A distributed HTAP database compatible with the MySQL protocol.
  • MariaDBstars4k - Community developed fork of MySQL server.
  • MySQL Server & MySQL Clusterstars7.1k - Official Oracle's MySQL server & MySQL Cluster distribution.
  • Percona Server - An enhanced, drop-in MySQL replacement.
  • Sharding

  • vitessstars12.7k - vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services.
  • jetpantsstars1.1k - An automation suite for managing large range sharding clusters, by Tumblr.
  • Toolkits

  • gh-oststars9.4k - GitHub's online schema migration for MySQL.
  • openark kit - a set of utilities that solve everyday maintenance tasks, which may be complicated or time consuming to do by hand, written in Python.
  • 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.
  • go-mysqlstars3.3k - A pure go library to handle MySQL network protocol and replication.
  • MySQL Utilities - a collection of command-line utilities, written in Python, that are used for maintaining and administering MySQL servers, either individually, or within Replication hierarchies.
  • Conferences

  • Percona Live - MySQL & Openstack focused conference.
  • SCALE - A community organized Linux and Open Source conference held annually in Southern California. The local MySQL community runs a track under the name MySQL Community Day.
  • 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.
  • e-books

  • SQL-exercisestars910 - contains several SQL exercises, including the schema description figure, SQL code to build schema, questions and solutions in SQL. Based on wikibook SQL Exercises.
  • Benchmarking

  • iibench-mysqlstars43 - Java based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB.
  • Sysbenchstars4.2k - a modular, cross-platform and multi-threaded benchmark tool.
  • TPCC-MySQL - A port of the popular TPCC benchmark for MySQL.
  • ChatOps

  • Hubot MySQL ChatOpsstars87
  • Last Checked At: 2021-10-25T04:20:45.888Z
    Previous
    numetriclabz/awesome-db
    Next
    mark-rushakoff/awesome-influxdb

    About

    Track your favorite github awesome repo, not just star it. trackawesomelist.com provides website, newsletter, RSS for tracking the popular awesome list by daily and weekly.
    Contact us: [email protected]
    Track Awesome List - Track your favorite Github awesome repos, not just star them | Product Hunt

    Subscribe

    Subscribe to our weekly newsletter to receive the awesome updates! We never send spam and you can unsubscribe instantly with one click. Here's past issues.

    Links

    Follow us on TwitterSubscribe us on TelegramSubmit awesome list repoNewsletterDonateSitemap