MySQL High Availability

MySQL High Availability

1 INTRODUCTION

1.1 Learning Objectives
1.2 The MySQL Overview
1.2.1 MySQL Partners
1.3 MySQL Products
1.3.1 MySQL Database Products
1.3.2 MySQL GUI Tools
1.3.3 Other MySQL Tools
1.3.4 MySQL Drivers
1.3.5 Solutions for Embedding MySQL
1.4 MySQL Services
1.4.1 MySQL Training
1.4.2 MySQL Certification
1.4.3 MySQL Consulting
1.4.4 MySQL Support
1.5 Community vs. Enterprise
1.6 Supported Operating Systems
1.7 MySQL Certification Program
1.8 Training Curriculum Paths
1.9 MySQL Website
1.9.1 MySQL Community Web Page
1.10 Installing MySQL
1.11 Installing the "world" database
1.12 Chapter Summary

2 INTRODUCTION TO MY SQL HIGH AVAILABILITY

2.1 Overview
2.2 What is High Availability?
2.2.1 Availability defined
2.2.2 Downtime
2.2.3 Scheduled vs. Unplanned Downtime
2.2.4 Business Impact
2.3 Overview of Availability Terminology
2.3.1 Asynchronous vs. Synchronous
2.3.2 Replication vs. Clustering
2.3.3 Shared-nothing vs. Shared-disk
2.4 Third Party Software
2.4.1 Linux-HA
2.4.2 Windows Clustering
2.4.3 Veritas Cluster Agent
2.4.4 Red Hat Cluster Suite
2.5 Heartbeat
2.5.1 Configuration
2.5.2 Hardware
2.6 Summary

3 MY SQL REPLICATION Overview

3.2 Basic architecture
3.3 Binary logging
3.3.1 Statement Based Binary Logging
3.3.2 Row based binary logging
3.3.3 Row Based vs. Statement Based Binary Logging
3.4 Replication threads and files
3.4.1 Replication threads
3.4.2 Replication files
3.5 Setting up MySQL Replication
3.6 Monitoring MySQL Replication.
3.6.1 Error Log
3.6.2 Replication Slave I/O Thread States
3.6.3 Replication Slave SQL Thread States
3.7 Advantages and Disadvantages of MySQL Replication
3.8 Advanced Replication Topologies
3.8.1 Two-way Replication
3.8.2 Circular Replication
3.9 Other Uses of Replication.
3.9.1 Controlled Switchover
3.9.2 Online Schema Changes
3.9.3 Software Upgrades
3.10 Replication Optimization
3.10.1 Different Storage Engines
3.10.2 Different Startup Variables
3.10.3 Different Logical Structure
3.10.4 Different Hardware
3.11 Summary

4 MY SQL CLUSTER .

4.1 Overview
4.2 Architecture
4.2.1 Introduction.
4.2.2 Node types
4.2.3 Data storage
4.2.4 High Availability
4.2.5 Limitations of MySQL Cluster
4.2.6 Common use cases
4.3 Setup of MySQL Cluster
4.3.1 Cluster Configuration
4.3.1.1 Other Configuration Files
4.3.2 Starting the Cluster
4.4 Managing the Cluster
4.4.1 Logging
4.5 Cluster Asynchronous Replication
4.6 Cluster Pros and Cons
4.7 Summary

5 SHARED DISK CLUSTERING

5.1 Overview.
5.2 Shared Disk Clustering Overview
5.2.1 Active-Active vs. Active-Passive
5.3 Active-Passive Setups
5.4 Active-Active Clustering
5.5 Usage cases
5.5.1 Pros and Cons
5.5.2 Combining with Replication
5.6 Summary

6 OTHER CLUSTERING 1

6.1 Learning Objectives
6.2 Continuent uni/cluster® Product Architecture
6.2.1 Application Overview
6.2.2 Access Continuent uni/cluster with MySQL
6.2.3 Inside the controller
6.3 DRBD Details.
6.3.1 DRBD Compared to Other Technologies
6.3.2 Configuring DRBD for MySQL
6.4 DRBD and Heartbeat
6.4.1 Configuring DRBD and Heartbeat
6.4.2 Example failover scenarios
6.4.3 Node Fencing and STONITH devices
6.5 Other DRBD Benefits
6.6 Additional Resources
6.7 Summary

7 SYSTEM MAINTENANCE IMPACTS

7.1 Overview
7.2 Introduction
7.3 Backups
7.3.1 mysqldump
7.3.2 Storage engine specific tools
7.3.3 Cold backup
7.3.4 File system snapshots
7.3.5 Summary of full backup options
7.3.6 Incremental Backups
7.4 Table Reorganization
7.5 Schema Alterations
7.6 Index Optimizations
7.7 Conclusions
7.8 Summary

8 HIGH AVAILABILITY CONCLUSIONS

8.1 Overview
8.2 Overview of Availability Tools
8.2.1 Replication
8.2.2 MySQL Cluster
8.2.3 Shared Disk Clustering
8.2.4 DRBD
8.2.5 High Availability Overview
8.3 Combinations
8.4 Summary

9 CONCLUSION

9.1 Course Objectives
9.2 Training and Certification Website
9.3 Course Evaluation