Module 1: Introduction to MySQL
- MySQL overview
- MySQL Enterprise Edition
- MySQL on the Web
- MySQL in the Cloud
- The MySQL community
Module 2: Installing MySQL
- Installing MySQL
- Installed Files and Directories
- Initial Configuration
- Starting and Stopping MySQL
- Upgrading MySQL
Module 3: MySQL Architecture
- Architectural Overview
- How MySQL Transmits Data
- How MySQL Processes Requests
- How MySQL Stores Data
- Tablespaces
- Redo and Undo Logs
- How MySQL Uses Memory
- Plug-in Interface
Module 4: Configuring MySQL
- Server Options, Variables, and the Command Line
- Option Files
- System Variables
- Launching Multiple Servers on the Same Host
Module 5: Monitoring MySQL
- Monitoring MySQL with Log Files
- Monitoring MySQL with Status Variables
- Monitoring MySQL with Performance Schema
- MySQL Enterprise Audit
- MySQL Enterprise Monitor
- Monitoring User Activity
Module 6: User Management
- MySQL Privilege System
- Creating and Modifying User Accounts
- Configuring Passwords and Account Expiration
- Authentication Plug-Ins
- Granting Permissions
- Grant Tables
- Resetting a Forgotten Root Password
Module 7: MySQL Security
- Security Risks
- Network Security
- Secure Connections
- Password Security
- Operating System Security
- Protecting Against SQL Injections
- MySQL Enterprise Firewall
Module 8: Maintaining a Stable System
- Stability
- Why Databases Fail
- Capacity Planning
- Troubleshooting
- Identifying the Causes of Server Slowdowns
- InnoDB Recovery
Module 9: Optimizing Query Performance
- Identifying Slow Queries
- The EXPLAIN statement
- Working with Indexes
- Index Statistics
Module 10: Backup Strategies
- Understanding Backups
- Backup Techniques
- Creating a Backup Strategy
Module 11: Performing Backups
- MySQL Backup Tools
- Raw Backup Methods
- Techniques that Use the Binary Log
Module 12: Configuring a Replication Topology
- Overview of Replication
- Replication Conflicts
- When to Use Replication
- Configuring Replication
Module 13: Administering a Replication Topology
- Failover
- MySQL Utilities
- Replication Threads
- Monitoring Replication
- Troubleshooting Replication
Module 12: Group Replication
- Overview
- Single-Primary and Multi-Primary Modes
- Configuring Group Replication
- Monitoring Group Replication
Module 13: Conclusion
- Course Overview
- MySQL Curriculum
- Course Evaluation
- Thank You!
- Q&A Session