mysql
Installation
Summary
MySQL database administration, optimization, and development for production environments.
- Covers core administration tasks including installation, user management, backup with mysqldump, binary log management, and configuration tuning
- Query development support for SELECT, JOINs, subqueries, stored procedures, triggers, and events
- Performance optimization through EXPLAIN analysis, index tuning, slow query log review, and Performance Schema inspection
- High availability setup including MySQL replication, group replication, MySQL Router, ProxySQL, and failover strategies
- Requires SQL fundamentals, Linux basics, and networking knowledge
SKILL.md
MySQL Skill
Overview
Master MySQL database administration, optimization, and development for production environments.
Topics Covered
MySQL Basics
- Installation and configuration
- User management
- Database creation
- Storage engines (InnoDB, MyISAM)
- Character sets
Query Development
- SELECT statements
- JOINs and subqueries
- INSERT, UPDATE, DELETE
- Stored procedures
- Triggers and events
Performance
- EXPLAIN analysis
- Index optimization
- Query cache (8.0+ changes)
- Slow query log
- Performance Schema
Administration
- Backup with mysqldump
- Binary log management
- Replication setup
- User privileges
- Configuration tuning
High Availability
- MySQL replication
- Group replication
- MySQL Router
- ProxySQL
- Failover strategies
Prerequisites
- SQL fundamentals
- Linux basics
- Networking concepts
Learning Outcomes
- Administer MySQL servers
- Optimize queries
- Set up replication
- Manage backups