Professional Training

Learn how to

Install and configure MySQL Server and client programs
Recognize the key components of the MySQL architecture
Manage user accounts and secure your server
Troubleshoot server slowdowns and other issues
Backup and recover MySQL database
Configure and administer a variety of replication topologies

Course Objectives

Install the MySQL server and client programs
Upgrade MySQL on a running server
Describe MySQL architecture
Explain how MySQL processes, stores, and transmits data
Configure MySQL server and client programs
Use server logs and other tools to monitor database activity
Create and manage users and roles
Protect your data from common security risks
Troubleshoot server slowdowns and other common problems
Identify and optimize poorly performing queries
Define and implement a backup strategy
Perform physical and logical backups of your data
Describe MySQL replication and its role in high availability and scalability
Configure simple and complex replication topologies
Administer a replication topology
Configure and administer InnoDB Cluster

Pre-requisites

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

Who should attend

Cloud Administrators
Database Administrators
Database Designers
Web Administrators

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