Essential MySQL Learning Resources: Books, Tools, and Utilities for DBA Beginners

SQL Fundamentals

Before becoming a MySQL DBA, proficiency in SQL syntax, joins, EXISTS, subqueries, and basic data manipulation is essential. Mastering equivalent transformations between EXISTS and JOIN, row‑column conversions, and procedural constructs (loops, cursors) reduces later troubleshooting time.

Recommended References

SQL Cookbook – step‑by‑step examples for common business scenarios in MySQL, SQL Server and Oracle. Useful as a learning path and as a quick‑reference.

The Art of SQL – focuses on SQL design and tactical optimization; best read in the original English.

SQL Application Refactoring – title only, details omitted.

O’Reilly MySQL Stored Procedure Programming (Mar 2006) – comprehensive guide to MySQL stored‑procedure syntax; despite its age the language features remain stable.

MySQL Introductory and Advanced Books

After mastering generic SQL, study MySQL‑specific architecture and performance tuning.

High Performance MySQL (3rd edition) – de‑facto bible covering server configuration, indexing, query optimization, replication, backup, and monitoring. Suitable for both thorough reading and as a reference.

深入浅出 MySQL 数据库开发、优化与管理维护 – Chinese‑language book that introduces MySQL features, basic administration, and performance concepts for beginners.

MySQL技术内幕 InnoDB存储引擎 – deep code‑level analysis of the InnoDB engine, including page layout, MVCC, redo/undo logs, and lock management.

Additional Learning Resources

Our Episode – weekly audio program discussing specific MySQL topics; useful for technical learning and English listening practice.

MySQL Planet – aggregated RSS feed of blogs from leading MySQL experts; a convenient way to stay updated on new features and best practices.

MOOC platforms – many free online courses provide introductory MySQL lectures; search for “MySQL” on Coursera, edX, or similar sites.

MySQL Tool Collection

The following tools cover performance testing, real‑time status monitoring, client utilities, middleware, version management, and connectors.

Tool Suites

percona‑toolkit – https://www.percona.com/software/mysql-tools/percona-toolkit oak‑toolkit – http://code.openark.org/forge/openark-kit ps‑helper (performance‑schema helper) –

https://github.com/MarkLeith/dbahelper

Real‑time Status Analysis

innotop – https://code.google.com/p/innotop/ orzdba – http://code.taobao.org/p/orzdba/src/trunk/orzdba mytop – http://jeremy.zawodny.com/mysql/mytop/ systemtap examples –

https://sourceware.org/systemtap/examples/

Client & Development Tools

MySQL Workbench – http://www.mysql.com/products/workbench/ SQLyog – https://www.webyog.com/ Adminer – https://www.adminer.org/ MyQuery – https://sourceforge.net/projects/myquery/ Hopper (stored‑procedure debugger) –

http://www.upscene.com/products.hopper.index.php

Performance Monitoring

mysql‑statsd – https://github.com/db-art/mysql-statsd nethogs –

http://www.oschina.net/p/nethogs/

Performance Benchmarking

sysbench – https://launchpad.net/sysbench tpcc‑mysql –

https://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql

dbt2 – https://sourceforge.net/projects/osdldbt/files/dbt2/ LinkBench – https://github.com/facebookarchive/linkbench iibench (Indexed Insertion Benchmark) –

https://github.com/tmcallaghan/iibench-mysql

Data Generators

Generatedata.com – http://www.generatedata.com/ OpenStreetMap geographic data –

http://www.openstreetmap.org/#map=5/51.500/-0.100

Database Routing Middleware

mysql‑proxy – http://downloads.mysql.com/archives/proxy/ Atlas – https://github.com/Qihoo360/Atlas mycat – https://code.google.com/p/opencloudb/ MaxScale – https://github.com/mariadb-corporation/MaxScale GLB – https://github.com/codership/glb ScaleArc –

http://www.scalearc.com/

Database Version Management

Liquibase –

http://www.liquibase.org/

MySQL Connectors

libAttachSQL –

http://libattachsql.org/