CFR-210-1 – MySQL for Database Administrators Ed 4

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