mysql
MySQL database administration and development
When & Why to Use This Skill
This Claude skill provides comprehensive expertise in MySQL database administration and development. It enables users to master database configuration, complex SQL query optimization, performance analysis using EXPLAIN, and high-availability strategies like replication and failover to ensure robust and scalable production environments.
Use Cases
- Database Performance Tuning: Analyzing slow query logs and using EXPLAIN analysis to optimize indexes and query execution plans for faster response times.
- System Administration: Managing user privileges, performing secure backups with mysqldump, and configuring storage engines like InnoDB for optimal data integrity.
- Backend Development: Designing complex relational schemas, writing efficient JOINs and subqueries, and implementing stored procedures or triggers to automate database logic.
- High Availability Setup: Configuring MySQL replication, Group Replication, and ProxySQL to ensure data redundancy, load balancing, and automated failover strategies.
| name | mysql |
|---|---|
| description | MySQL database administration and development |
| sasmp_version | "1.3.0" |
| bonded_agent | 02-postgresql-dba |
| bond_type | PRIMARY_BOND |
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