MySQL for Database Administrators

Course Overview

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!
• QA Session

Prerequisites

• Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands.