Awesome Lists

awesome-mysql

by shlomi-noach

awesome listpushed almost 2 years ago

A curated list of awesome MySQL software, libraries, tools and resources

AI summary

MySQL management toolbox

A curated collection of tools and resources for managing and optimizing MySQL databases

stars
2.4K
forks
379
watching
121
awesome lists
9
entries
90
View on GitHub

Embed the badge

Show how many awesome lists link to your project. The count updates automatically.

Awesome Lists badge
Markdown
[![Awesome Lists Badge](https://awesome.facts.dev/shield/shlomi-noach/awesome-mysql/links.svg)](https://awesome.facts.dev/awesome/shlomi-noach/awesome-mysql)
HTML
<a href="https://awesome.facts.dev/awesome/shlomi-noach/awesome-mysql"><img src="https://awesome.facts.dev/shield/shlomi-noach/awesome-mysql/links.svg" alt="Awesome Lists Badge" /></a>
Image URL
https://awesome.facts.dev/shield/shlomi-noach/awesome-mysql/links.svg

What's in the list

90 links in 19 sections, with live GitHub stats.activeno commit in 2y

Analysis

  • 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 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

    / - 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

  • 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

  • go-tpc

    A golang port of and 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 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

Configuration

Connectors

  • 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

  • MariaDB Connector/J

    LGPL-licensed MariaDB Client Library for Java Applications

  • mex-mariadb

    MIT licensed MariaDB/MySQL Client Library for GNU Octave and Matlab

  • MySQL C API

    Official C driver for MySQL

  • MySQL Connector/C++

    Official C/C++ driver for MySQL

  • MySQL Connector/J

    a standardized database driver for the Java platforms and development

  • MySQL Connector/NET

    a standardized database driver for .Net platforms and development

  • MySQL Connector/Node.js

    Official Node.js driver for MySQL

  • MySQL Connector/Python

    a standardized database driver for Python platforms and development

  • mysqlclient-python

    MySQL database connector for Python

  • node-mysql

    A pure Nodejs Javascript client implementing the MySQL protocol

  • PHP mysqlnd

    MySQL native driver for PHP

  • PyMySQL

    MySQL database connector for Python

  • Ruby Mysql2 gem

    MySQL driver for Ruby and Rails projects

  • MyZql

    MySQL and MariaDB driver in native Zig

Deployment

  • dbdeployer

    (archived) - A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control

  • MariaDB4j

    A Java launcher to run MariaDB without installation or external dependencies

  • MySQL Docker

    Official Docker images

Development

  • Flywaydb

    Database migrations; Evolve your database schema easily and reliably across all your instances

  • Liquibase

    Source control for your database

  • Shift

    An application that helps you run schema migrations on MySQL databases

  • Skeema

    Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools

  • SQLE

    SQLE is a SQL audit platform for DBA or developer

  • Test database

    A sample MySQL database with an integrated test suite, used to test applications and servers

GUI

  • Adminer

    Database management in a single PHP file

  • DBeaver

    A cross-platform SQL and NoSQL database client

  • HeidiSQL

    MySQL GUI frontend for Windows

  • ILLA Cloud

    Low-code internal tool builder integrated with Mysql, can be used as GUI for Mysql

  • mycli

    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

  • MySQL Workbench

    provides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration

  • Ocelot GUI

    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

  • pspg

    provides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL

  • Sequel Ace

    a Mac database management application for working with MySQL databases

  • SQLyog Community edition

    SQLyog Community edition. For Windows, works fine under wine in Mac and Linux

  • WebDB

    – Open Source and Efficient Database IDE. Featuring Easy server connection, Modern ERD, Intelligent data generator, AI assistant, NoSQL structure manager, Time machine and Powerful query editor

HA

  • Galera Cluster

    a true Multimaster Cluster based on synchronous replication

  • mha4mysql-node

    and (both unmaintained) - Master High Availability Manager and tools for MySQL

  • Orchestrator

    MySQL replication topology management and High Availability solution

  • Percona Replication Manager

    Asynchronous MySQL replication manager agent for Pacemaker. Supports file and GTID based replication, geo-distributed clusters using booth

  • replication-manager

    a high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies

Proxy

  • MySQL Proxy

    (deprecated) - A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication

  • 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

  • ProxySQL

    High performance proxy for MySQL

Replication

  • data-diff

    Command-line tool and Python library to efficiently diff rows across two different databases

Schema

  • 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

Security

  • Acra

    SQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system

Server

  • 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

  • TiDB

    A distributed HTAP database compatible with the MySQL protocol

Sharding

  • Jetpants

    An automation suite for managing large range sharding clusters, by Tumblr

  • Vitess

    vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services

Toolkits

  • gh-ost

    GitHub's online schema migration for MySQL

  • go-mysql

    A pure go library to handle MySQL network protocol and replication

  • MySQL Utilities

    (deprecated) - a collection of command-line utilities, written in Python, that are used for maintaining and administering MySQL servers, either individually, or within Replication hierarchies

  • 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 / 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

  • SQL-exercise

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

More related projects

Add a GitHub project

Missing a project or an awesome list? Paste its GitHub URL and we fetch it right away.