Installing MySQL
Install MySQL
Identify installed Files and Directories
Understand Initial Configuration
Start and Stop MySQL
Configuring MySQL
Understand Server Options, Variables, and the Command Line
Define Option Files
Use System Variables
User Management
Identify MySQL Privilege System
Create and Modify User Accounts
Configure Passwords and Account Expiration
Create Roles
Understand Authentication Plug-Ins
Grant Permissions
Reset a Forgotten Root Password
Maintaining a Stable System
Define Stability
Use Capacity Planning
Troubleshoot
Identify the Causes of Server Slowdowns
Describe InnoDB Recovery
Backup Strategies
Understand Backups
Create a Backup Strategy
Use MySQL Backup Tools
Define Raw Backup Methods
Explain Techniques that Use the Binary Log
MySQL Architecture
Understand How MySQL Processes Requests
Explain How MySQL Stores Data
Use Tablespaces
Identify Redo and Undo Logs
Define How MySQL Uses Memory
Monitoring MySQL
Monitor MySQL with Log Files
Monitor MySQL with Status Variables
Monitor MySQL with Performance Schema
MySQL Security
Identify Security Risks
Understand Network security
Use Password Security
Explain Operating System Security
Protect Against SQL Injections
Optimizing Query Performance
Identify Slow Queries
Understand the EXPLAIN statement
Work with Indexes
Use Index Statistics
Configuring a Replication Topology
Replicate Conflicts
Explain Replication
Configure Replication
Use MySQL Utilities
Identify Replication Threads
Monitor Replication
Troubleshoot Replication
Architecture
Configure client connections to the server
Understand how MySQL stores data
Understand how InnoDB stores data and logs
Configure buffers and caches
Understand and use the Data Dictionary
Server Installation and Configuration
Install and use the MySQL server and client programs
Identify the files and folders created during installation
Start and stop MySQL
Upgrade MySQL
Configure MySQL by using options and option files
Configure MySQL variables
Launch multiple MySQL servers on the same host
Security
Create user accounts and roles
Use authentication plug-ins
Control user and role permissions
Recognize common security risks
Secure MySQL server connections
Provide password and login security
Secure the MySQL host environment
Prevent SQL injection attacks
Encrypt MySQL data
Configure MySQL Enterprise Firewall
Monitoring and Maintenance
Configure and view MySQL log files
Monitor MySQL processes and status
Configure MySQL Enterprise Audit
Use MySQL Enterprise Monitor to view activity in MySQL
Monitor database growth and explain capacity planning
Troubleshoot problems with locked resources
Query Optimization
Examine how MySQL optimizes queries
Analyze queries with MySQL Enterprise Monitor
Create indexes to improve server performance
Monitor and understand index statistics
Backups and Recovery
Distinguish between the different types of backup
Implement a backup strategy
Backup and restore data with MySQL Enterprise Backup
Use mysqldump and mysqlpump to perform logical backups
Explain when and how to use raw file backups
Back up the binary log
High Availability Techniques
Explain how replication provides high availability and scalability
Configure replication
Explain the role of the binary log in replication
Configure multisource replication
Explain the role of replication threads
Monitor and troubleshoot replication
Describe MySQL InnoDB cluster and Group Replication
Configure a MySQL InnoDB cluster
Perform an InnoDB cluster recovery