Databases
MySQL Database Administration
Administer, secure, and scale MySQL for web-scale and enterprise workloads.
4 DaysIntermediateTensorNova Certificate of Completion
Course Curriculum
Module 1Installation & Configuration
- MySQL 8.0 installation on Linux
- my.cnf key parameters
- MySQL Shell and Workbench
- Character sets and collations
Module 2Security & User Management
- Authentication plugins
- Privilege system and roles
- MySQL Enterprise Firewall
- SSL/TLS for encrypted connections
Module 3Backup & Recovery
- Logical backup with mysqldump
- MySQL Enterprise Backup (mysqlbackup)
- Binary log for point-in-time recovery
- Restoring from backup
Module 4Replication & HA
- Asynchronous and semi-synchronous replication
- GTID-based replication
- MySQL Group Replication
- InnoDB Cluster and MySQL Router
Module 5Performance Tuning
- InnoDB buffer pool tuning
- EXPLAIN and query optimisation
- Performance Schema and sys schema
- Slow query log analysis
Prerequisites
- Basic SQL knowledge
- Linux command-line proficiency
- No prior MySQL DBA experience required
Who Should Attend
- Web developers managing their own MySQL server
- Junior DBAs taking MySQL responsibilities
- DevOps engineers managing database infrastructure
Get Started
Interested in MySQL Database Administration?
Our training advisors will help you choose the right batch format, dates, and pricing for your team or individual goals.