MySQL overview
- Properties, versions, editions, components, compared with other DB
- Overview and tools for administrators
- Architecture of the MySQL database system
Installation and configuration in a Windows environment
- Preparing for installation (Windows)
- Getting the installation media and the choice of distribution
- Using multiple instances of MySQL on a single server
- Installation procedure
- Recommended configuration (CPU, Memory, etc.)
Installation and configuration in a Linux environment
- Installing from the repository distribution
- Installing from source package
- Configure and start the database system
Configuration and database management
- Overview of database structure
- System database
- Database configuration
Backing up and restoring databases
- Properties backup process
- Types of database backups and their combinations
- Using Tools
- Database recovery scenarios and practical use
Security
- Authentication mode of user connections
- Creating and managing users
- Types and set permissions
- Audit, logging and tracking users
MySQL monitoring
- Tools for Monitoring MySQL
- Monitoring active connections
- Analysis of performance indicators
- Solving performance problems
Maintenance and automation tasks
- Reason for using automation
- Design and creation of automated tasks
- Maintenance database system (defragmentation, etc.)
Data import and export
- Overview and application of methods for data import
- Overview and application of methods for data export
Troubleshooting
- Methods and procedures to identify and solve problems
- Troubleshooting service level
- Solving the concurency problems
- Troubleshooting the connection level
