MariaDB / Advanced: evidence and reliable operations

MariaDB β€” Advanced: evidence and reliable operations

Investigate workloads and plan recovery, replication, compatibility and controlled change.

6 lessons Β· No account required

What you will learn

  • Diagnose performance and recovery boundaries from evidence.
  • Review MariaDB-specific JSON, stored code and migration risks.

  1. Optimizer evidence and workload performance

    Diagnose a slow dispatch report by separating estimation errors, query work and system contention. Use MariaDB instrumentation with explicit operational boundaries.

    Start learning

  2. Restore rehearsals and point-in-time recovery

    Build a recovery runbook that can stop before an accidental change. Preserve evidence, apply a verified backup chain and prove application correctness before cutover.

    Start learning

  3. Replication, GTIDs and Galera concepts

    Compare asynchronous replication with Galera certification and interpret replica health. Design consistency and failover requirements before selecting topology.

    Start learning

  4. JSON and MariaDB compatibility boundaries

    Store flexible parcel metadata while preserving relational integrity and searchable values. Understand why MariaDB JSON is not MySQL binary JSON.

    Start learning

  5. Stored routines, triggers and events

    Use stored code where its execution and privilege boundaries are clear. Distinguish functions, procedures, row triggers and scheduled events.

    Start learning

  6. Migration and operational reliability

    Plan a MariaDB upgrade or MySQL migration as a reversible evidence-driven change. Integrate schema evolution, service routing, recovery and version maintenance.

    Start learning
Back to course