.webp)
.svg)
Program overview
Online
On-site
Hybrid
MySQL and MariaDB Administration
Three days of practical administration for teams running MySQL or MariaDB in production. Covers architecture and InnoDB internals, configuration, users and authentication, backup and recovery, replication topologies, monitoring, query tuning, security hardening and upgrades. Taught on MySQL 8.4 LTS and MariaDB 11.4 LTS with the behavioural differences between the two called out explicitly rather than glossed over.
Duration:
3 Days
Level:
Intermediate
.avif)
1500+ users onboarded
Who will Benefit from this Training?
Training Objectives
Build a high-performing, job-ready tech team.
Personalise your team’s upskilling roadmap and design a befitting, hands-on training program with Uptut
Key training modules
Comprehensive, hands-on modules designed to take you from basics to advanced concepts
Download Curriculum
- Architecture, Editions and Fork History
- Server layers: connection handling, parser, optimiser and storage engines
- Thread model, memory allocation and per-connection buffers
- MySQL and MariaDB divergence and what it means for portability
- Release and support lifecycle for both projects
- Percona Server and other distributions in the ecosystem
- Hands-on: inspect a running server's configuration, threads and status
- Installation, Configuration and Instance Management
- Package, binary and container based installation
- Configuration file structure, precedence and dynamic variables
- Data directory layout and file placement decisions
- Running multiple instances on a single host
- Startup, shutdown, safe restarts and recovery on start
- Hands-on: deploy and configure a server for a stated workload profile
- InnoDB Internals and Storage Engines
- Buffer pool structure, sizing and warm-up behaviour
- Redo log, undo tablespaces and the doublewrite buffer
- Clustered index organisation and the cost of a wide primary key
- Tablespace layout, file-per-table and compression options
- Alternative engines and where they still make sense
- Hands-on: size the buffer pool against a working set and measure hit ratio
- Users, Privileges and Authentication
- Account naming, host matching and privilege scope
- Global, database, table and column level grants
- Roles and privilege grouping in both MySQL and MariaDB
- Authentication plugins, caching_sha2_password and legacy migration
- Password policies, expiry and account locking
- Hands-on: build a least-privilege account model and audit effective grants
- Schema, Table and Data Management
- Data type selection and its effect on storage and index size
- Character sets, collations and the utf8mb4 migration trap
- Online DDL, instant ALTER and lock behaviour by operation
- pt-online-schema-change and gh-ost for large table changes
- Partitioning options and their limitations
- Hands-on: alter a large table with no meaningful downtime
- Indexes and Execution Plans
- B-tree index structure and leftmost prefix behaviour
- Covering indexes, index-only reads and secondary index lookups
- EXPLAIN and EXPLAIN ANALYZE output interpretation
- Optimiser hints, index hints and histogram statistics
- Detecting unused, duplicate and redundant indexes
- Hands-on: tune a slow query set using plan evidence alone
- Transactions, Locking and Isolation
- Isolation levels and MySQL's repeatable read specifics
- Row locks, gap locks and next-key locking behaviour
- Deadlock detection and reading the deadlock report
- Metadata locks and why a long query blocks a DDL statement
- Designing transactions for short duration and consistent ordering
- Hands-on: reproduce a deadlock and redesign the transaction to avoid it
- Backup, Recovery and Binary Logs
- mysqldump and mysqlpump for logical backups and their limits
- Percona XtraBackup and MariaBackup for physical hot backups
- Binary log formats, retention and their role in recovery
- Point-in-time recovery using a base backup plus binary logs
- Backup verification, retention policy and offsite storage
- Hands-on: recover a dropped table to the second before it was dropped
- Replication and Topologies
- Asynchronous, semi-synchronous and their consistency implications
- GTID based replication setup and administration
- Multi-source replication and read scaling topologies
- Replication lag causes, parallel appliers and lag monitoring
- Group Replication, InnoDB Cluster and MariaDB Galera compared
- Failover, promotion and rebuilding a broken replica
- Hands-on: build a replica, break replication deliberately and repair it
- Monitoring, Diagnostics and Tuning
- Performance schema and sys schema views that matter operationally
- Slow query log configuration and pt-query-digest analysis
- Status variables worth alerting on and the ones that only create noise
- Prometheus exporters and dashboard design
- Memory, I/O and connection level tuning
- Hands-on: triage an unknown performance incident from instrumentation
- Security, Upgrades and Day-Two Operations
- Network exposure, TLS enforcement and certificate management
- Encryption at rest and keyring management
- Audit plugin configuration for compliance evidence
- Minor patching and major version upgrade paths for both engines
- Migrating between MySQL and MariaDB and the compatibility gaps
- Operational differences on RDS, Aurora, Azure Database and Cloud SQL
- Hands-on: capstone upgrade of a replicated pair with a rollback plan
Hands-on Experience with Tools
Training Delivery Format
Flexible, comprehensive training designed to fit your schedule and learning preferences
Opt-in Certifications
AWS, Scrum.org, DASA & more
.avif)
100% Live
on-site/online training
.avif)
Hands-on
Labs and capstone projects
.avif)
Lifetime Access
to training material and sessions
Skill-Gap Assessment
Analysing skill gap and assessing business requirements to craft a unique program
1
Personalisation
Customising curriculum and projects to prepare your team for challenges within your industry
2
Implementation
Supplementing training with consulting support to ensure implementation in real projects
3
Why this course
- Both engines, differences named: MySQL and MariaDB have diverged significantly. The course covers both and is explicit about where they behave differently.
- Recovery you have actually rehearsed: Participants restore from binary logs to a point in time rather than reading about it.
- Replication that survives failure: GTID based replication, lag diagnosis and failover are taught as operational skills, not configuration snippets.
- Self-managed and cloud: Covers self-hosted servers alongside RDS, Aurora MySQL, Azure Database and Cloud SQL operations.
Training objectives
- Explain MySQL and MariaDB architecture, threading and memory structures
- Install, configure and secure a server for a defined workload
- Describe InnoDB internals including the buffer pool, redo log and undo
- Manage users, privileges, roles and authentication plugins
- Design and execute backup strategies using logical and physical methods
- Perform point-in-time recovery using binary logs
- Build and operate GTID based replication topologies
- Diagnose replication lag, errors and failover safely
- Read execution plans and tune indexes and queries
- Monitor a server using performance schema, sys schema and slow query analysis
- Harden and upgrade a server with a documented rollback path
Who will benefit
- Database administrators supporting MySQL or MariaDB
- DevOps, platform and site reliability engineers
- Backend developers responsible for their own database servers
- Cloud engineers managing RDS, Aurora or Cloud SQL instances
- Teams migrating between MySQL and MariaDB or consolidating both
.avif)
Lead the Digital Landscape with Cutting-Edge Tech and In-House " Techsperts "
Discover the power of digital transformation with train-to-deliver programs from Uptut's experts. Backed by 70,000+ professionals across the world's leading tech innovators.
.svg)
.svg)
.svg)
.svg)
.svg)
Recommended Training
Continue your learning journey with these hand-picked courses and bundles
Frequently Asked Questions
2. Will my team get any practical experience with this training?
.svg)
With our focus on experiential learning, we have made the training as hands-on as possible with assignments, quizzes and capstone projects, and a lab where trainees will learn by doing tasks live.
3. What is your mode of delivery - online or on-site?
We conduct both online and on-site training sessions. You can choose any according to the convenience of your team.
4. Will trainees get certified?
Yes, all trainees will get certificates issued by Uptut under the guidance of industry experts.
5. What do we do if we need further support after the training?
We have an incredible team of mentors that are available for consultations in case your team needs further assistance. Our experienced team of mentors is ready to guide your team and resolve their queries to utilize the training in the best possible way. Just book a consultation to get support.