mysql
MySQL database administration and development
MySQL database administration and development
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
You Might Also Like
Related Skills
zig-system-calls
Guides using bun.sys for system calls and file I/O in Zig. Use when implementing file operations instead of std.fs or std.posix.
oven-sh
bun-file-io
Use this when you are working on file operations like reading, writing, scanning, or deleting files. It summarizes the preferred file APIs and patterns used in this repo. It also notes when to use filesystem helpers for directories.
anomalyco
vector-index-tuning
Optimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.
wshobsonsimilarity-search-patterns
Implement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.
wshobsondbt-transformation-patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
wshobsonevent-store-design
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.
wshobson