OM-DA8: MySQL 8.0 Database Administrator

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 Stop
• 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
• 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
• 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 Permission

Module 7: Securing 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 indexs
• 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 Backup

• 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 mqsqldump and mysqlpump
• Practice 11-3: Restoring the Database Using 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 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
• 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