MySQL High Availability with InnoDB Cluster ELS

Course Description

MySQL High Availability with InnoDB Cluster ELS develops practical capability in innodb cluster architecture, group replication, mysql shell, and prerequisites and cluster creation, member management, recovery, consistency, and quorum. The course connects Oracle architecture, configuration, development, or functional processing to ownership, security, data quality, controls, and measurable acceptance criteria.

The later modules cover mysql router, read and write routing, failover, maintenance, and scaling and monitoring, backup, security, failure drills, performance, and troubleshooting. Learners use instance checks, cluster metadata, member state, replication status to distinguish configuration defects from data, access, integration, performance, or operational failures.

By completing the learning path, participants can support a MySQL InnoDB Cluster designed to preserve service during member failure, maintenance, and controlled recovery. They also produce an improvement plan covering validation, exception handling, rollback, ownership, monitoring, and production support.

What You Will Learn

• Map the relationships among InnoDB Cluster Architecture, Group Replication before implementation begins.
• Build a repeatable setup for MySQL Shell, Prerequisites, using instance checks as acceptance evidence.
• Process Cluster Creation, Member Management through a controlled sequence with traceable checkpoints.
• Recognise configuration mismatch by examining Recovery, Consistency, Quorum at the point where the issue first appears.
• Trace MySQL Router, Read from source input to the resulting Oracle outcome.
• Assess Write Routing, Failover, Maintenance with failover results, including a boundary or exception case.
• Administer Monitoring, Backup with defined monitoring, recovery, and handover responsibilities.
• Improve resilience to split-brain assumptions by reviewing Security, Failure Drills, Performance and assigning preventive follow-up.

SkillDynamo Training Approach

Delivery combines Oracle-specific demonstrations, guided hands-on exercises, scenario analysis, validation checklists, structured troubleshooting, peer review, and a final improvement plan. Learners document assumptions, settings, data, outputs, exceptions, corrective actions, rollback needs, approvals, evidence, and operational responsibilities.