September 16, 2021

TECH HYME

A Blog For Tech Enthusiasts

[Top 60] List of MySQL Repositories, GUI, Backup and Analysis Tools

4 min read
mysql resources tools tech hyme

Most interactive websites nowadays require information to exist dynamically and interactively based upon input from the user. So there are basically two ways to store the data i.e. in Files and in Database (MySQL, PostgreSQL, MSSQL, MariaDB, ODBC, SQL, NoSQL, etc).

One of the most prevalent databases in use is MySQL as the data can easily be indexed, managed and stored efficiently. The vital component of any database is the inherent database management technology that classifies and tracks the documents created and stored.

Suggested Read Articles:

So here in this article, we’ve listed out top 60 scripts and tools through which you can easily manage your MySQL database and performs various tasks such as taking backups, GUI interface tools, database analysis etc.

S.No. Name Action
1 Anemometer a MySQL Slow Query Monitor Read More
2 Innotop a ‘top’ clone for MySQL Read More
3 Explain Analyzer the web based MySQL explain analyzer Read More
4 Mysql-statsd a daemon that gathers statistics from MySQL and sends them to statsd Read More
5 PMM (Percona Monitoring and Management) a free, open-source monitoring tool for MySQL, PostgreSQL, MongoDB and ProxySQL Read More
6 MySQL Server Exporter – Prometheus exporter for MySQL server metrics Read More
7 Ps-top – a ‘top’ like program for MySQL Read More
8 Dumpling – a tool and a Go library for creating SQL dump from a MySQL-compatible DB Read More
9 Mydumper – Logical, parallel backup/dumper tool for MySQL Read More
10 Percona XtraBackup – an open-source hot backup utility for MySQL Read More
11 iibench-mysql – iiBench Benchmark for MySQL / Percona / MariaDB Read More
12 Go TPC – A toolbox to benchmark workloads in TPC for TiDB and almost MySQL compatible databases Read More
13 Sysbench – a modular, cross-platform and multi-threaded benchmark tool Read More
14 TPCC MySQL – A port of the popular TPCC benchmark for MySQL. Read More
15 TiDB – Data Migration Platform Read More
16 Kingbus a distributed MySQL binlog store based on raft Read More
17 Ripple – Ripple is a server that can serve as a middleman in MySQL replication. Read More
18 Hubot – A small collection of MySQL ChatOps scripts. Read More
19 MySQL Compatibility Config – Make MySQL behave more like newer (or older) releases of MySQL. Read More
20 MySQL Docker – Official Docker Images Read More
21 DBdeployer – a tool that deploys MySQL database servers easily Read More
22 Test DB – a sample DB with an integrated test suite used to test your app and DB servers Read More
23 Skeema – the best way to manage MySQL table definitions Read More
24 Shift – an application that makes it easy to run online schema migrations for MySQL DBs Read More
25 Liquidbase – Track, version, and deploy database changes Read More
26 Adminer – DB management in a single PHP file Read More
27 HeidiSQL – MySQL GUI frontend for Windows. Read More
28 Mycli – a command line client for MySQL Read More
29 MySQL Shell – Advanced client and code editor for MySQL Read More
30 MySQL Workbench – provides DBAs and developers an integrated tools environment Read More
31 Ocelot GUI – a GUI client for MySQL or MariaDB, including debugger Read More
32 PhpMyAdmin – a free software tool written in PHP, intended to handle the administration of MySQL over the Web Read More
33 PSPG Postgres Pager – Originally implemented for PostgreSQL, but also supports MySQL. Read More
34 Sequel Pro – a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases Read More
35 SQLyog Community edition – SQLyog Community edition. For Windows, works fine under wine in Mac and Linux Read More
36 DBeaver – A cross-platform SQL and NoSQL database client. Read More
37 OmniDB – a web tool for database management Read More
38 Galera Cluster – a true Multimaster Cluster based on synchronous replication. Read More
30 MHA – Master High Availability Manager and tools for MySQL. Read More
40 Orchestrator – MySQL replication topology management and High Availability solution. Read More
41 Replication Manager – an high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies Read More
42 MaxScale – an intelligent proxy that allows forwarding of database statements Read More
43 Mixer – Mixer is a MySQL proxy powered by Go which aims to supply a simple solution for MySQL sharding Read More
44 MySQL Proxy – A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication Read More
45 ProxySQL – High performance proxy for MySQL Read More
46 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. Read More
47 Common Schema – DBA’s framework for MySQL Read More
48 Sys – The MySQL sys schema Read More
49 Acra – Database protection suite with field level encryption and intrusion detection Read More
50 MariaDB – Community developed fork of MySQL server. Read More
51 MySQL Server & MySQL Cluster – Official Oracle’s MySQL server & MySQL Cluster distribution. Read More
52 TiDB – a distributed SQL database Read More
53 Jetpants – An automation suite for managing large range sharding clusters, by Tumblr. Read More
54 Vitess – Vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services. Read More
55 Gh-ost – GitHub’s online schema migration for MySQL Read More
56 Go Mysql – a pure go library to handle MySQL network protocol and replication Read More
57 MySQL Utilities – a collection of command-line utilities, written in Python Read More
58 Openark kit – Common utilities for MySQL Read More
59 Percona Toolkit – a collection of advanced command-line tools to perform a variety of MySQL server and system tasks Read More
60 TwinDB data recovery toolkit – a set of tools that operate with MySQL files at low level and allow to recover InnoDB databases after different failure scenarios Read More

Leave a Reply