CONTENT
1. MySQL Architecture
1.1 MySQL’s Logical Architecture
1.2 Concurrency Control
1.3 Transactions
1.4 Multiversion Concurrency Control
1.5 Replication
1.6 Datafiles Structure
1.7 The InnoDB Engine
2. Monitoring in a Reliability Engineering World
2.1 The Impact of Reliability Engineering on DBA Teams
2.2 Defining Service Level Goals
2.3 What to Measure
2.4 Measuring Long-Term Performance
3. Performance Schema
3.1 Introduction to Performance Schema
3.2 Configuration
3.3 Using Performance Schema
4. Operating System and Hardware Optimization
4.1 What Limits MySQL’s Performance?
4.2 How to Select CPUs for MySQL
4.3 Balancing Memory and Disk Resources
4.4 Solid-State Storage
4.5 RAID Performance Optimization
4.6 Network Configuration
4.7 Choosing a Filesystem
5. Optimizing Server Settings
5.1 How MySQL’s Configuration Works
5.2 What Not to Do
5.3 Creating a MySQL Configuration File
5.4 Configuring Memory Usage
5.5 Configuring MySQL’s I/O Behavior
5.6 Configuring MySQL Concurrency
5.7 Safety Settings
5.8 Advanced InnoDB Settings
6. Schema Design and Management
6.1 Choosing Optimal Data Types
6.2 Schema Design Gotchas in MySQL
6.3 Schema Management
7. Indexing for High Performance
7.1 Indexing Basics
7.2 Indexing Strategies for High Performance
7.3 Index and Table Maintenance
8. Query Performance Optimization
8.1 Why Are Queries Slow?
8.2 Slow Query Basics: Optimize Data Access
8.3 Ways to Restructure Queries
8.4 Query Execution Basics
8.5 Limitations of the MySQL Query Optimizer
8.6 Optimizing Specific Types of Queries
9. Replication
9.1 Replication Overview
9.2 Replication Under the Hood
9.3 Replication Failover
9.4 Replication Topologies
9.5 Replication Administration and Maintenance
9.6 Replication Problems and Solutions
10. Backup and Recovery
10.1 Why Backups?
10.2 Defining Recovery Requirements
10.3 Designing a MySQL Backup Solution
10.4 Managing and Backing Up Binary Logs
10.5 Backup and Recovery Tools
10.6 Backing Up Data
10.7 Recovering from a Backup
11. Scaling MySQL
11.1 What Is Scaling?
11.2 Read- Versus Write-Bound Workloads
11.3 Functional Sharding
11.4 Scaling Reads with Read Pools
11.5 Queuing
11.6 Scaling Writes with Sharding
12. MySQL in the Cloud
12.1 Managed MySQL
12.2 MySQL on Virtual Machines
13. Compliance with MySQL
13.1 What Is Compliance?
13.2 Building for Compliance Controls
Course Features
- Lectures 0
- Quizzes 0
- Duration 4 days
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
