MySQL Skill

This skill allows you to generate standardized Kubernetes manifests for MySQL, focusing on StatefulSets, hostNetwork, and persistent storage.

Core Features

• Headless Service: Provides stable network identifiers and exposes both MySQL (3306) and Metrics (9104) ports.
• StatefulSet: Manages MySQL pods with ordered deployment and built-in health checks (Readiness/Liveness probes).
• hostNetwork: Uses the node’s network namespace (with ClusterFirstWithHostNet DNS policy).
• Persistence: Uses volumeClaimTemplates with configurable StorageClass (defaults to local-path).
• Observability Sidecar: Integrated mysqld-exporter container within the same Pod for seamless monitoring.
• Resource Management: Configurable CPU/Memory requests and limits for both MySQL and Exporter.

Usage Guide

1. Generate Manifests: When asked to deploy MySQL, use scripts/generate_mysql.py.
2. Architecture Visualization: Every report or deployment plan MUST include a high-fidelity architecture diagram.
   • Use scripts/generate_visuals.py to create the JPG diagram.
3. Stress Testing: Use scripts/generate_stress_test.py to verify performance under load.
4. Reporting: Direct embedding of the generated .jpg file path in the report is mandatory.

Command Templates

Deploy MySQL with Sidecar Monitoring (Recommended)

python3 scripts/generate_mysql.py --name <name> --namespace <namespace> --storage <storage> --storage-class <sc_name> --with-exporter

Advanced Resource Control

python3 scripts/generate_mysql.py --cpu-request 1 --mem-request 2Gi --cpu-limit 2 --mem-limit 4Gi

Stress Testing with Sysbench

python3 scripts/generate_stress_test.py --host <mysql_host> --namespace <namespace> --threads 8 --time 600

Generate Architecture Diagram (JPG)

python3 scripts/generate_visuals.py --name <name> --namespace <namespace> --storage <storage> --output mysql-arch.jpg

Aesthetic Standards

• Color: Pastel palette with high-contrast black borders.
• Accessibility: Distinct shapes for different roles (e.g., Hexagon for Services, Cylinder for PVC).
• Fidelity: Detailed logical clusters to reduce variance between generated reports.

Sidecar Configuration Example

When --with-exporter is used, the pod spec includes:

      containers:
      - name: mysql
        image: mysql:8.0
        # ...
      - name: mysqld-exporter
        image: prom/mysqld-exporter:v0.14.0
        env:
        - name: DATA_SOURCE_NAME
          value: "root:<password>@tcp(localhost:3306)/"