Training objectives
- Understand MySQL database architecture and storage engines as well as the differences with MariaDB
- Install and configure MySQL/MariaDB databases according to the best practices
- Operate and secure MySQL/MariaDB databases
- Backup and recover MySQL/MariaDB databases
Topics
- MySQL semantic structure and the differences to MariaDB
- MySQL/ MariaDB architecture: files, memory, processes
- MySQL/MariaDB storage engines
- MySQL/MariaDB network layer
- MySQL/MariaDB installation according to the OFA standard
- Running several MySQL/MariaDB servers in different versions on the same host
- Starting/stopping MySQL/MariaDB
- Backup strategies with MySQL/MariaDB
- Securing MySQL/MariaDB databases
- Upgrading MySQL/MariaDB databases
Method
- Presentation with countless practical exercises and trainings
- Case studies, Live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA), developers, etc.
Language & documentation
- Workshop training normally held in English; French or German as course language are also possible
- Documentation: content details, scripts, case study solutions as PDF file (in English)