Home All Courses Comprehensive explanation of MySQL architecture design
Comprehensive explanation of MySQL architecture design

Advanced 4.3

12 months 30 days

$389.00 $311.00

0 Learners 26 Reviews 1 Favorites

15%
85%
0%
0%
0%
4.3
  • Overview
  • Outline
  • Reviews
  • Packages

How to get optimal performance for MySQL? How to build a MySQL highly available cluster? How to build a stable and efficient MySQL environment?

Examples and stories

  • What determines the success or failure of the E-commerce Double 11 Promotion
    01:01
  • Database servers in the Double 11 Promotion
    01:50
  • What affects database performance in the promotion
    01:50
  • Problems caused by large watches
    01:01
  • Problems caused by big things
    01:01

What affects MySQL performance

  • Several aspects that affect performance
    01:01
  • CPU resources and available memory size
    01:50
  • Disk configuration and selection
    01:50
  • Use RAID to increase the performance of traditional machine hard drives
    01:01
  • Use solid-state storage SSD or PCIe card
    20:14
  • Using networked storage SAN and NAS
    20:29
  • Summary: The impact of server hardware on performance
    21:56
  • Operating system impact on performance-MySQL's suitable operating system
    26:50
  • Optimization of CentOS system parameters
    21:48
  • Impact of file systems on performance
    13:14
  • MySQL Architecture
    15:25
  • MySQL's common storage engines MyISAM
    26:57
  • Innodb of MySQL's commonly used storage engines
    16:00
  • Features of Innodb Storage Engine (1)
    18:34
  • Features of Innodb Storage Engine (2)
    13:14
  • CSV of MySQL's common storage engines
    11:03
  • Archive of MySQL Common Storage Engines
    17:08
  • Memory of MySQL's common storage engines
    12:17
  • MySQL Common Storage Engines Federated
    16:59
  • How to choose a storage engine
    29:55
  • Introduction to MySQL server parameters
    12:39
  • Memory configuration related parameters
    17:25
  • IO-related configuration parameters
    13:42
  • Safety-related configuration parameters
    19:18
  • Other commonly used configuration parameters
    18:39
  • Impact of database design on performance
    13:14
  • summary
    17:15

MySQL Benchmarking

  • What is a benchmark test
    25:45
  • How to benchmark
    11:33
  • Benchmark demonstration examples
    22:33
  • Mysql benchmark tool mysqlslap
    12:32
  • Mysql benchmark tool sysbench
    21:30
  • sysbench benchmark demonstration example
    14:17

MySQL database structure optimization

  • Introduction to database structure optimization
    17:29
  • database structure design
    15:59
  • Requirements analysis and logic design
    23:00
  • Requirements Analysis and Logic Design-Anti-Normal Design
    23:35
  • Advantages and disadvantages of paradigm design and anti-paradigm design
    19:33
  • Introduction to Physical Design
    26:01
  • Physical Design-Choice of Data Type
    13:46
  • Physical Design-How to Store Date Types
    21:58
  • Physical Design-Summary
    20:39

MySQL High Availability Architecture Design

  • Introduction to mysql copy function
    16:21
  • mysql binary log
    25:53
  • Impact of mysql binary log format on replication
    15:08
  • How mysql copying works
    14:58
  • Log point-based replication
    19:19
  • GTID-based replication
    19:30
  • MySQL Replication Topology
    16:08
  • MySQL replication performance optimization
    16:04
  • Handling common problems in MySQL replication
    12:02
  • What is a highly available architecture
    21:10
  • Introduction to MMM Architecture
    19:12
  • MMM Architecture Example Demonstration (Part 1)
    20:44
  • MMM Architecture Example Demonstration (Part 2)
    26:32
  • Advantages and disadvantages of MMM architecture
    14:43
  • Introduction to MHA Architecture
    26:45
  • MHA Architecture Example Demonstration (1)
    11:36
  • MHA Architecture Example Demonstration (2)
    18:36
  • Advantages and disadvantages of MHA architecture
    21:47
  • Introduction to Read-Write Separation and Load Balancer
    17:48
  • MaxScale example demonstration
    27:13

Database index optimization

  • Btree index and Hash index
    17:01
  • Install the presentation database
    28:06
  • Index optimization strategy (Part 1)
    11:57
  • Index Optimization Strategy (Part 2)
    10:09
  • Index optimization strategy (Part 2)
    28:29

SQL query optimization

  • Three ways to get SQL with performance problems
    25:51
  • Introduction to Slow Query Log
    16:31
  • Slow query log examples
    16:27
  • Get performance issues in real time SQL
    14:27
  • SQL parsing preprocessing and generation execution plan
    18:05
  • How to determine the time consumed in each stage of query processing
    25:18
  • Query optimization for specific SQL
    16:38

Sub-database and table of database

  • Several ways to divide database and table
    26:42
  • Preparation before database fragmentation
    21:09
  • Database sharding demonstration (Part 1)
    28:57
  • Database fragmentation demonstration (Part 2)
    23:56

database monitoring

  • Introduction to database monitoring
    18:22
  • Database availability monitoring
    27:50
  • database performance monitoring
    12:52
  • MySQL Master-slave replication monitoring
    01:01
  • Testing Testing
    01:01
  • Test Test 2
    01:01
Login
Instructor
sqlercn
sqlercn
数据库工程师
0
26
1