打造扛得住的MySQL数据库架构

• Chapter1 Examples and stories
• 1-1 What determines the success or failure of the e-commerce Double 11 promotion?
• 1-2 Database server in Double 11 promotion
• 1-3 What affects database performance during big sales
• 1-4 Problems caused by large watches
• 1-5 Problems caused by big events
• Chapter2 What affects MySQL performance
• 2-1 Several aspects that affect performance
• 2-2 CPU resources and available memory size
• 2-3 Disk configuration and selection
• 2-4 Using RAID to increase the performance of traditional machine hard drives
• 2-5 Use solid state storage SSD or PCIe card
• 2-6 Using network storage SAN and NAS
• 2-7 Summary: The Impact of Server Hardware on Performance
• 2-8 The impact of operating system on performance-The operating system suitable for MySQL
• 2-9 CentOS system parameter optimization
• 2-10 File system impact on performance
• 2-11 MySQL architecture
• 2-12 MySQL commonly used storage engine MyISAM
• 2-13 Innodb, a commonly used storage engine for MySQL
• 2-14 Features of Innodb storage engine (1)
• 2-15 Features of Innodb storage engine (2)
• 2-16 MySQL commonly used storage engine CSV
• 2-17 Archive, a commonly used storage engine for MySQL
• 2-18 MySQL commonly used storage engine Memory
• 2-19 Federated, a commonly used storage engine for MySQL
• 2-20 How to choose a storage engine
• 2-21 Introduction to MySQL server parameters
• 2-22 Memory configuration related parameters
• 2-23 IO related configuration parameters
• 2-24 Security related configuration parameters
• 2-25 Other common configuration parameters
• 2-26 Impact of database design on performance
• 2-27 Summarize
• Chapter3 MySQL Benchmark
• 3-1 What is benchmark testing
• 3-2 How to benchmark
• 3-3 Benchmark demo example
• 3-4 Mysql benchmark tool mysqlslap
• 3-5 Mysql benchmarking tool sysbench
• 3-6 sysbench benchmark test demonstration example
• Chapter4 MySQL database structure optimization
• 4-1 Introduction to database structure optimization
• 4-2 Database structure design
• 4-3 Requirements analysis and logical design
• 4-4 Requirements analysis and logical design-anti-paradigm design
• 4-5 Advantages and disadvantages of normalized design and denormalized design
• 4-6 Introduction to physical design
• 4-7 Physical design-selection of data types
• 4-8 Physical design - how to store date type
• 4-9 Physical Design - Summary
• Chapter5 MySQL high availability architecture design
• 5-1 Introduction to mysql replication function
• 5-2 mysql binary log
• 5-3 The impact of mysql binary log format on replication
• 5-4 How mysql replication works
• 5-5 Logpoint-based replication
• 5-6 GTID based replication
• 5-7 MySQL replication topology
• 5-8 MySQL replication performance optimization
• 5-9 MySQL replication FAQs
• 5-10 What is high availability architecture
• 5-11 Introduction to MMM architecture
• 5-12 MMM architecture example demonstration (Part 1)
• 5-13 MMM architecture example demonstration (Part 2)
• 5-14 Advantages and disadvantages of MMM architecture
• 5-15 Introduction to MHA architecture
• 5-16 MHA architecture example demonstration (1)
• 5-17 MHA architecture example demonstration (2)
• 5-18 MHA architecture advantages and disadvantages
• 5-19 Introduction to read-write separation and load balancing
• 5-20 MaxScale example demonstration
• Chapter6 Database index optimization
• 6-1 Btree index and Hash index
• 6-2 Install the demo database
• 6-3 Index optimization strategy (Part 1)
• 6-4 Index optimization strategy (medium)
• 6-5 Index optimization strategy (Part 2)
• Chapter7 SQL query optimization
• 7-1 Three ways to obtain SQL with performance issues
• 7-2 Introduction to slow query log
• 7-3 Slow query log example
• 7-4 Get performance problem SQL in real time
• 7-5 SQL parsing preprocessing and execution plan generation
• 7-6 How to determine the time spent in various stages of query processing
• 7-7 Query optimization for specific SQL
• Chapter8 Database sub-tables
• 8-1 Several ways to divide databases into tables
• 8-2 Preparation before database sharding
• 8-3 Database sharding demonstration (Part 1)
• 8-4 Database sharding demonstration (Part 2)
• Chapter9 Database monitoring
• 9-1 Introduction to database monitoring
• 9-2 Database availability monitoring
• 9-3 Database performance monitoring
• 9-4 MySQL master-slave replication monitoring