Course - MySQL database design and architecture optimization

For more than ten years, a database architect for front-line e-commerce enterprises, taking e-commerce projects as an example, he will teach you how to design a high-performance and scalable tens of millions of database architecture step by step from the basic design, and provide a variety of solutions for high load and high concurrency problems. solution

Formulation of database development specifications

course description

14:37
course preparation

26:19
Introduction to E-commerce Project

29:07
Introduction to Database Design Specifications

24:35
Database naming convention

12:33
Database basic design specification

18:15
Database index design specification

12:06
Database Field Design Specifications

12:40
SQL Development Specifications

18:40
Database operation specifications

27:55

Structure design of e-commerce example database

E-commerce project user module

29:26
Hash partition table

26:15
Range partition

10:33
List partition

25:39
Project zoning table demonstration

14:23
Product module

20:32
order module

14:59
DB planning

19:19

MySQL execution plan (explain) analysis

Common business processing

25:17
Execution plan analysis

21:09
How to optimize the paging query example

23:50
Example of how to delete duplicate data

19:11
Examples of how to conduct interval data statistics

25:27
Capture problematic SQL-Slow Log Check

26:57

MySQL database backup and recovery

database backup

25:31
mysqldump fully prepared introduction

17:10
mysqldump fully prepared single library example

15:25
mysqldump is fully equipped with all libraries and all table instances

20:54
mysqldump full backup Where and script backup

28:33
mysqldump recovery

25:32
mysqldump recovery instance

26:57
mysqldump recovery single table instance

28:53
Recovery at specified point in time

14:36
Binlog recovery at a specified time

12:39
Real-time binlog backup

20:39
xtrabackup and recovery

29:11
Mysql backup plan

19:37

High-performance and high-availability MySQL architecture changes

mysql master-slave replication configuration

25:01
mysql master-slave copy demonstration

21:20
GTID-based replication links

14:59
Highly available keepalived instances

23:55
Mysql database read-write separation

14:25
Using LVS to Solve Read Load Balancer

16:23
Solving Read Load Balancer Using maxscale Database Middleware

28:33
Use DB business splitting to solve the problem of writing pressure

13:00
Course summary and thinking

27:22