Top 50 Awesome List

shlomi-noach/awesome-mysql

Databases  3 months ago  1.9k
A curated list of awesome MySQL software, libraries, tools and resources
View byDAY/WEEK/README
View on Github

awesome-mysql

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

This list accepts and encourages pull requests. See CONTRIBUTING

Contents

Analysis

Performance, structure & data analysis tools

Backup

Backup/restore/recovery tools

  • Dumplingstars266 - Logical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
  • MyDumperstars1.8k - 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.

Benchmarking

Tools to stress your servers

Binlog-Replication

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

ChatOps

Scripts integrated into chat rooms

Configuration

MySQL sample configuration and advisors

Connectors

MySQL connectors for various programming languages

Deployment

MySQL deployment tools

  • MySQL Docker - Official Docker images.
  • dbdeployer - 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
  • Shiftstars723 - 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
  • Test databasestars3.2k - A sample MySQL database with an integrated test suite, used to test applications and servers

GUI

GUI frontends & applications

  • Adminer - Database management in a single PHP file.
  • HeidiSQL - MySQL GUI frontend for Windows.
  • myclistars10.6k - 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 GUIstars53 - 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.9k - provides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL.
  • Sequel Acestars4.9k - 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
  • DBeaverstars28.4k - A cross-platform SQL and NoSQL database client.
  • OmniDB/OmniDB: Web tool for database managementstars2.9k

HA

High availability solutions

  • Galera Cluster - a true Multimaster Cluster based on synchronous replication.
  • MHA - Master High Availability Manager and tools for MySQL.
  • orchestratorstars4.7k - 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-managerstars538 - a high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies.

Proxy

Proxies to MySQL

  • MaxScalestars1.2k - open-source, database-centric proxy.
  • Mixerstars742 - 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.
  • ProxySQLstars23 - High performance proxy for MySQL.
  • 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.

Replication

Replication related software

  • data-diffstars1.7k - Command-line tool and Python library to efficiently diff rows across two different databases.

Schema

Add-on schemas

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

Security

Tools that prevents leaking of sensitive data from database (encryption, masking and tokenization, honey-pots, etc)

  • Acrastars1.1k - SQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system.

Server

MySQL server flavors

Sharding

Sharding solutions/frameworks

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

Toolkits

Toolkits, general purpose scripts

  • gh-oststars10.4k - GitHub's online schema migration for MySQL.
  • go-mysqlstars3.8k - 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.
  • 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.

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

e-books

e-books as well as relevant materials on and around MySQL

  • 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-exercisestars1.1k - contains several SQL exercises, including the schema description figure, SQL code to build schema, questions and solutions in SQL. Based on wikibook SQL Exercises.

Media

Public, ongoing video & audio casts. This excludes conference presentations in fear of list size

Newsletters

Newsletters require an email address, by definition. List below are newsletters that require nothing but an email address

ON THIS PAGE

  1. awesome-mysql
  2. Contents
  3. Analysis
  4. Backup
  5. Benchmarking
  6. Binlog-Replication
  7. ChatOps
  8. Configuration
  9. Connectors
  10. Deployment
  11. Development
  12. GUI
  13. HA
  14. Proxy
  15. Replication
  16. Schema
  17. Security
  18. Server
  19. Sharding
  20. Toolkits
  21. Resources
  22. Conferences
  23. e-books
  24. Media
  25. Newsletters
Last Checked At: 2022-09-21T14:32:12.664Z
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