Mysql Operations

---
name: mysql-operations
description: Use when administering, tuning, backing up, restoring, monitoring, or troubleshooting MySQL production systems. Load absorbed MySQL administration and query-performance reference files for operational runbooks, indexes, replication, and incident response.
metadata:
  portable: true
  compatible_with:
  - claude-code
  - codex
---

# MySQL Operations
Acknowledgement: Shared by Peter Bamuhigire, techguypeter.com, +256 784 464178.

Use this parent skill as the active MySQL operations entrypoint. Operational advice must be tied to observable evidence and a reversible execution path.

<!-- dual-compat-start -->
## Use When

- Troubleshooting slow queries, lock waits, replication lag, connection exhaustion, deadlocks, or storage pressure.
- Designing backup, restore, HA, monitoring, capacity, and maintenance plans for MySQL.
- Reviewing production configuration, operational runbooks, and incident evidence.

## Do Not Use When

- The task is unrelated to this parent skill or is better handled by a narrower active parent named in the workflow.
- The request only needs a trivial answer and no reference module needs to be loaded.

## Required Inputs

- Gather the concrete system, repository, environment, constraints, and deliverable before loading references.
- Identify which absorbed reference file is needed; do not load every migrated reference by default.
## Workflow

1. Load `database-reliability` for SLOs, recovery objectives, and incident handling.
2. Load the task-specific reference:
   - `references/mysql-administration.md` for roles, backup, restore, replication, upgrades, and maintenance.
   - `references/mysql-query-performance.md` for query tuning, indexes, EXPLAIN review, and capacity analysis.
3. Pair with `mysql-engineering` when schema or SQL changes are part of the work.
4. Pair with `observability-monitoring` for dashboards, alerts, and production telemetry.

## Quality Standards

- State measurement source, rollback path, and verification command before production changes.
- Treat backup restore tests as required evidence, not documentation claims.
- Avoid global tuning changes when query, index, or workload fixes are the real issue.

## Anti-Patterns

- Treating absorbed reference files as active skills or separate routing entrypoints.
- Loading every migrated child reference instead of the one that matches the task.
- Producing generic advice without constraints, evidence, or next verification steps.
## Outputs

- MySQL runbook, tuning plan, incident review, backup/restore plan, or operational checklist.

## References

- Load only the references/<old-skill>.md files named in the workflow when their depth is required.
<!-- dual-compat-end -->

## Inputs
| Input | Required | Purpose |
|---|---|---|
| MySQL version, topology, and workload | yes | Bound operations |
| SLO, RPO, and RTO | yes | Set recovery policy |
| Metrics, logs, and backup inventory | yes | Ground diagnosis |

## Capability contract
Diagnose read-only by default. Configuration changes, failover, restores, session termination, and replication repair require explicit production authority and rollback criteria.

## Degraded mode
If telemetry or privileged access is unavailable, return safe inspection commands and ranked hypotheses; do not infer root cause or recovery readiness.

## Decision rules
| Condition | Action |
|---|---|
| Data loss is possible | Preserve evidence and stop writes if authorised |
| Replica lag is growing | Find workload cause before tuning buffers |
| Restore is untested | Report RTO and RPO as unverified |

## Domain Anti-Patterns
- Restarting before evidence capture. Fix: collect logs and status.
- Tuning global buffers by folklore. Fix: measure memory and workload.
- Repairing replication by skipping errors. Fix: reconcile data first.
- Keeping backups on the same host. Fix: isolate and test copies.
- Running unbounded maintenance on primary. Fix: throttle and monitor.