Detailed Course Outline
Introduction to MySQL
- MySQL overview
- MySQL Enterprise Edition
- MySQL on the Web
- MySQL in the Cloud
- The MySQL community
Installing MySQL
- Installing MySQL
- Installed Files and Directories
- Initial Configuration
- Starting and Stopping MySQL
- Upgrading MySQL
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
Configuring MySQL
- Server Options, Variables, and the Command Line
- Option Files
- System Variables
- Launching Multiple Servers on the Same Host
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
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
MySQL Security
- Security Risks
- Network Security
- Secure Connections
- Password Security
- Operating System Security
- Protecting Against SQL Injections
- MySQL Enterprise Firewall
Maintaining a Stable System
- Stability
- Why Databases Fail
- Capacity Planning
- Troubleshooting
- Identifying the Causes of Server Slowdowns
- InnoDB Recovery
Optimizing Query Performance
- Identifying Slow Queries
- The EXPLAIN statement
- Working with Indexes
- Index Statistics
Backup Strategies
- Understanding Backups
- Backup Techniques
- Creating a Backup Strategy
Performing Backups
- MySQL Backup Tools
- Raw Backup Methods
- Techniques that Use the Binary Log
Configuring a Replication Topology
- Overview of Replication
- Replication Conflicts
- When to Use Replication
- Configuring Replication
Administering a Replication Topology
- Failover
- MySQL Utilities
- Replication Threads
- Monitoring Replication
- Troubleshooting Replication
Group Replication
- Overview
- Single-Primary and Multi-Primary Modes
- Configuring Group Replication
- Monitoring Group Replication
Conclusion
- Course Overview
- MySQL Curriculum
- Course Evaluation
- Thank You!
- Q&A Session