MySQL 1Z0-908 Study Plan: Administration, Replication, and Availability
March 28, 2026
MySQL 1Z0-908 study plan covering administration, backup, security, replication, and availability review order.
Most candidates pass 1Z0-908 with 70-140 focused hours, faster if they already run MySQL in production.
| Your time |
Recommended timeline |
| 18-22 hrs/week |
30 days (intensive) |
| 10-14 hrs/week |
60 days (balanced) |
| 6-9 hrs/week |
90 days (part-time) |
How to use this plan
- Use the resources page as your checklist of canonical MySQL references.
- Build a small lab, even with local containers, so you can rehearse user setup, backups, restores, and replication steps.
- Keep a runbook log for restore steps, failover steps, and the commands you always forget.
- Send recurring misses to the local cheat sheet or glossary.
30-Day Intensive Plan (4 weeks)
| Week |
Focus |
Output |
| 1 |
Installation, configuration, and security fundamentals |
drills |
| 2 |
InnoDB operations, backups, and restore |
restore rehearsal |
| 3 |
Replication and HA patterns |
failover rehearsal |
| 4 |
Performance, monitoring, troubleshooting, and mixed review |
readiness check |
60-Day Balanced Plan (8 weeks)
| Week |
Focus |
Output |
| 1 |
Architecture and installation |
drills |
| 2 |
Configuration and logging |
drills |
| 3 |
Users, roles, TLS, access control |
drills |
| 4 |
InnoDB operations and storage behavior |
drills |
| 5 |
Backups and recovery |
restore rehearsal |
| 6 |
Replication and HA |
failover rehearsal |
| 7 |
Performance tuning and monitoring |
mixed sets |
| 8 |
Maintenance, troubleshooting, final review |
readiness check |
90-Day Part-Time Plan (12 weeks)
| Weeks |
Focus |
Output |
| 1-2 |
Install and configure |
drills |
| 3-4 |
Security and users |
drills |
| 5-6 |
InnoDB and capacity |
drills |
| 7-8 |
Backup and recovery |
restore rehearsal |
| 9-10 |
Replication and HA |
failover rehearsal |
| 11-12 |
Performance, ops, and review |
readiness check |
Booking signal
Book when you can:
- explain how you would recover from data loss with the available logs and backups
- choose between replication, restore, and configuration changes without hand-waving
- identify the safest operational path when answers are close
- reason about security, failover, and maintenance from a DBA point of view
Final 72 hours
- Re-read Cheat Sheet for backup, recovery, replication, and security traps
- Use FAQ to clean up any last-week uncertainty
- Keep Resources open for exact command or manual-section confirmation
Revised on Sunday, May 10, 2026