MySQL for Database Administrators (D61762) – Outline

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