Introduction to MySQL Cluster PXC

Introduction: This course takes project demonstrations as examples to explain the principle of PXC clusters, the differences between PXC data synchronization and Replication synchronization, multi-node concurrent writing in PXC, and the deployment of MySQL clusters in Docker virtual machines. It also verifies the data inconsistency of the Replication solution and the data consistency of the PXC solution through case studies

Chapter 1 Course Introduction

This chapter provides an overall introduction to the learning objectives and knowledge acquired in this course.

1-1 Introduction

1-2 Cases of Tmall's Double Eleven

1-3 Wechat Red Envelope Cases 

1-4 Goals and Methods of Technical Learning

1-5 Learning Objectives of Courses 

1-6 Hardware Environment Introduction 

Chapter 2: Principles of PXC

This chapter introduces the necessity of database clusters, demonstrating through projects that the background program encounters various outages in the deployment environment of database clusters, Tomcat clusters, Redis clusters, and Nginx load balancing, but still remains highly available. Finally, it introduces the principle of PXC data synchronization.

2-1 Introduction to Single-Node Databases

2-2 PXC cluster solution

2-3 Replication cluster solution

2-4 Introduction to System Architecture Scheme

2-5 APP Project Introduction

2-6 Docker Virtual Machine Deployment of MySQL Cluster

2-7 APP Project Demonstration

2-8 Introduction to PXC

2-9 PXC Test Cases

The working principle of 2-10 PXC clusters

Chapter 3: Strong Consistency of PXC Data

This chapter introduces the differences in data synchronization between the PXC and Replication cluster solutions.

3-1 Introduction to the Advantages and Disadvantages of PXC and Replication Solutions

3-2 Performance Comparison between PXC and Replication Schemes

Case 3-3 verifies the data inconsistency of the Replication scheme

Case studies 3-4 verify the data consistency of the PXC solution

Chapter 4 Concurrent Writes to Multiple Nodes in PXC

This chapter introduces and demonstrates the PXC multi-node concurrent write and HaProxy high availability solutions

4-1 PXC multi-node concurrent Write

4-2 PXC Multi-Node Concurrent Write Case

4-3 Introduction to Haproxy High Availability Solution

4-4 Haproxy High Availability Case 1

4-5 Haproxy High Availability Case 2