MySQL for Database Administrators 8.0

COURSE TOPICS

Module 1: Introduction to MySQL

• Introduction to MySQL
• MySQL Powers the Web
• Practice 1-1: Course Environment

Module 2: Installing and Upgrading MySQL

• Installing and Upgrading MySQL
• Linux MySQL Server Installation Directories
• Starting and Stopping MySQL
• Practice 2-1: Installing MySQL
• Practice 2-2: Connecting to MySQL
• Practice 2-3: Configuring the MySQL Service
• Practice 2-4: Upgrading MySQL
• Practice 2-5: Deploying MySQL with Docker

Module 3: Understanding MySQL Architecture

• Understanding MySQL Architecture
• Storage Layer
• What Is a Data Dictionary?
• Redo Logs
• Practice 3-1: Configuring Tablespaces
• Practice 3-2: Configuring the Buffer Pool

Module 4: Configuring MySQL

• Configuring MySQL
• Server System Variables
• Practice 4-1: Modifying a Setting by Using Command-Line Arguments
• Practice 4-2: Modifying the Configuration File
• Practice 4-3: Changing Dynamic Settings
• Practice 4-4: Persisting Global Variables
• Practice 4-5: Configuring the Client
• Practice 4-6: Running Multiple MySQL Servers on the Same Host with system

Module 5: Monitoring MySQL

• Monitoring MySQL
• Status Variables
• MySQL Enterprise Audit
• MySQL Enterprise Monitor
• Practice 5-1: Configuring the Slow Query Log
• Practice 5-2: Using Performance Schema
• Practice 5-3: Installing MySQL Enterprise Monitor
• Practice 5-4: Monitoring Server Activity

Module 6: Managing MySQL Users

• Managing MySQL Users
• Setting the Account Password
• Authorization
• Using Role Privileges
• Practice 6-1: Quiz-User Management
• Practice 6-2: Creating Users and Roles
• Practice 6-3: Granting Permissions

Module 7: Security MySQL

• Securing MySQL
• Preventing MySQL Password Security Risks
• Keyring
• MySQL Enterprise Firewall
• Practice 7-1: Quiz – Securing MySQL
• Practice 7-2: Enabling SSL for Secure Connections Practice 7-3: Encrypting MySQL Data-at-Rest
• Practice 7-4: Configuring MySQL Enterprise Firewall

Module 8: Maintaining a Stable System

• Maintaining a Stable System
• Capacity Planning
• Identifying the Causes of Server Slowdowns
• Practice 8-1: Quiz-Maintaining a Stable System
• Practice 8-2: Identifying the Cause of Slow Performance

Module 9: Optimizing Query Performance

• Optimizing Query Performance
• Index Statistics
• Practice 9-1: Improving Query Performance with Indexes
• Practice 9-2: Using MySQL Query Analyzer

Module 10 : Choosing a Backup Strategy

• Choosing a Backup Strategy
• Backup Techniques
• Practice 10-1: Quiz-Backup Strategies

Module 11: Performing Backups

• Performing Backups
• mysqldump and mysqlpump
• Physical InnoDB Backups: Overview
• Overview of practices for lesson 11
• Practice 11-1: Backing Up with MySQL Enterprise Backup
• Practice 11-2: Backing Up with mysqldump and mysqlpump
• Practice 11-3: Restoring the Database Using the Binary Log

Module 12: Configuring a Replication Topology

• Configuring a Replication Topology
• Replication Use Cases
• Binary Log Formats
• Asynchronous Replication
• Overview of practices for lesson 12
• Practice 12-1: Quiz-Configuring Replication
• Practice 12-2: Configuring Replication
• Practice 12-3: Adding a New Slave with the Cloning Method
• Practice 12-4: Enabling GTID and Configuring Circular Replication

Module 13: Administering a Replication Topology

• Administering a Replication Topology
• Monitoring Replication
• Troubleshooting MySQL Replication
• Practice 13-1: Monitoring Replication with MySQL Enterprise Monitor
• Practice 13-2: Troubleshooting Replication Errors
• Practice 13-3: Performing a Replication Failover

Module 14: Achieving High Availability with MySQL InnoDB Cluster

• Achieving High Availability with MySQL InnoDB Cluster
• MysQL Shell (mysqlsh)
• Managing Sandbox Instances
• Practice 14-1: Creating MySQL InnoDB Cluster
• Practice 14-2: Deploying MySQL Router and Testing the Cluster
• Practice 14-3: Testing High Availability

Module 15: Conclusion

• Conclusion