#MySQL Reference Resources

Main Documentation: https://dev.mysql.com/doc/
Reference Manual: https://dev.mysql.com/doc/refman/8.0/en/
Server Version: https://dev.mysql.com/doc/refman/8.0/en/server-administration.html
SQL Syntax: https://dev.mysql.com/doc/refman/8.0/en/sql-syntax.html

New Features: https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Performance Schema: https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
Data Dictionary: https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
Window Functions: https://dev.mysql.com/doc/refman/8.0/en/window-functions.html
Common Table Expressions: https://dev.mysql.com/doc/refman/8.0/en/common-table-expressions.html

W3Schools: https://www.w3schools.com/mysql/
MySQL Tutorial: https://www.mysqltutorial.org/
Tutorialspoint: https://www.tutorialspoint.com/mysql/
GeeksforGeeks: https://www.geeksforgeeks.org/mysql/
DigitalOcean: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04

Performance Tuning:
https://dev.mysql.com/doc/refman/8.0/en/optimization.html
https://www.percona.com/blog/

Replication:
https://dev.mysql.com/doc/refman/8.0/en/replication.html
https://www.percona.com/blog/percona-xtradb-cluster/

High Availability:
https://www.percona.com/blog/mysql-high-availability/

"MySQL 8.0 Reference Manual" by Oracle Corporation
"MySQL Cookbook" by Paul DuBois
"High Performance MySQL" by Baron Schwartz, Peter Zaitsev
"MySQL Admin Cookbook" by O'Reilly Media
"Learning MySQL" by Vinicius M. Grippa
"Pro MySQL" by Michael Kofler

"Database Design for Mere Mortals" by Michael Hernandez
"SQL Queries for Mere Mortals" by John L. Viescas
"Designing Data-Intensive Applications" by Martin Fowler

MySQL Channel: https://www.youtube.com/c/MySQLChannel
Programming with Mosh: https://www.youtube.com/watch?v=7S_t4p_2Eo
Traversy Media: https://www.youtube.com/watch?v=PxZkBx66aI
FreeCodeCamp: https://www.youtube.com/watch?v=HXV3eRRn1w

Udemy: https://www.udemy.com/topic/mysql/
Coursera: https://www.coursera.org/courses?query=mysql
Pluralsight: https://www.pluralsight.com/topics/mysql
LinkedIn Learning: https://www.linkedin.com/learning/topics/mysql

MySQL Forums: https://forums.mysql.com/
MySQL Bugs: https://bugs.mysql.com/
MySQL Workbench: https://forums.mysql.com/list.php?9

MySQL Tag: https://stackoverflow.com/questions/tagged/mysql
Search tips:
- Add "mysql" tag to search queries
- Browse recent questions
- Check accepted answers

r/MySQL: https://www.reddit.com/r/MySQL/
r/Database: https://www.reddit.com/r/Database/
r/SQL: https://www.reddit.com/r/SQL/

MySQL Workbench:
https://dev.mysql.com/downloads/workbench/
Official GUI tool with visual query builder, admin, and modeling

DBeaver:
https://dbeaver.io/
Open source universal database tool

Navicat:
https://www.navicat.com/
Commercial database administration tool

HeidiSQL:
https://www.heidisql.com/
Lightweight Windows GUI

phpMyAdmin:
https://www.phpmyadmin.net/
Web-based MySQL administration

MySQL Shell (mysqlsh):
https://dev.mysql.com/doc/mysql-shell/8.0/en/
Advanced client with JavaScript and Python support

mycli:
https://www.mycli.net/
Enhanced command line client with autocomplete

usql:
https://github.com/xelabs/usql
Universal SQL client with beautiful output

mysqldump:
Built-in backup tool

MySQL Workbench Migration Wizard:
Visual database migration tool

Percona XtraBackup:
https://www.percona.com/software/percona-xtrabackup/
Online non-blocking backups

mydumper:
https://github.com/maxbube/mydumper
Fast multi-threaded backup

Percona Monitoring and Management (PMM):
https://www.percona.com/software/percona-monitoring-and-management/
Open source monitoring solution

MySQL Enterprise Monitor:
Commercial monitoring from Oracle

Prometheus MySQL Exporter:
https://github.com/prometheus/mysqld_exporter
Open source metrics collection

MySQL Performance Blog:
https://www.percona.com/blog/
Official MySQL Performance Blog

Performance Schema Guide:
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html

Query Optimization:
https://dev.mysql.com/doc/refman/8.0/en/optimization.html

MySQL Tuner:
https://github.com/major/MySQLTuner-perl
Script to analyze MySQL performance

pt-index-usage:
https://www.percona.com/doc/percona-toolkit/LATEST/pt-index-usage.html
Analyze index usage

pt-query-digest:
Analyze slow query log

MySQL Sandbox:
https://github.com/datacharmer/mysql-sandbox
Install multiple MySQL versions for testing

Travis CI:
https://docs.travis-ci.com/
Continuous integration for MySQL projects

Jenkins MySQL Plugin:
https://plugins.jenkins.io/mysql/
Integration with Jenkins

MySQL Security Guide:
https://dev.mysql.com/doc/refman/8.0/en/general-security-issues.html

SQL Injection Prevention:
https://dev.mysql.com/doc/refman/8.0/en/sql-injection.html

OWASP SQL Injection:
https://owasp.org/www-community/attacks/SQL_Injection

MySQL Proxy:
https://dev.mysql.com/downloads/mysql-proxy/
Query analysis and routing

MySQL Enterprise Firewall:
Advanced threat detection

Vulnerability Scanners:
SQLMap
Nikto

MySQL Cheat Sheet:
https://devhints.com/mysql/

Cheatography: MySQL:
https://www.cheatography.com/mysql/

OverAPI MySQL:
https://overapi.com/mysql

MySQL Server Team Blog:
https://mysqlserverteam.com/
Official blog from MySQL developers

Percona Blog:
https://www.percona.com/blog/
High-quality technical articles

Vitess Blog:
https://vitess.io/blog/
Database scaling and sharding

Oracle MySQL Certification:
https://education.oracle.com/mysql-certification/
Certified MySQL 8.0 Database Administrator
Certified MySQL 8.0 Database Developer

Study Materials:
https://education.oracle.com/mysql-certification/study-materials.html

MySQL 8.0 Release Notes:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/

Change History:
https://dev.mysql.com/doc/refman/8.0/en/news.html

MySQL Planet:
https://planet.mysql.com/
Aggregator of MySQL-related content