MySQL performance tuning and architecture design is coming soon

It has been 10 months since I planned to write this book last year before and after now, and now the manuscript has been published and printed in the printing factory. According to the plan of the Publishing House, as long as there is no exception in the press, it will definitely be available before the end of the month. Thank you for your constant help and support and your attention. Here we will first release the final object

It has been 10 months since I planned to write this book last year before and after now, and now the manuscript has been published and printed in the printing factory. According to the plan of the Publishing House, as long as there is no exception in the press, it will definitely be available before the end of the month. Thank you for your constant help and support and your attention. Here we will first release the final object

It has been 10 months since I planned to write this book last year before and after now, and now the manuscript has been published and printed in the printing factory. According to the plan of the Publishing House, as long as there is no exception in the press, it will definitely be available before the end of the month.

Thank you for your constant help and support and your attention.

Here we first release the final directory structure:

1st Basics

• Chapter 2 Basic Introduction to MySQL

• • 1.0 Introduction
  • 1.1 MySQL Server Introduction
  • 1.2 simple comparison between MySQL and other databases
  • 1.3 Main application scenarios of MySQL
  • Conclusion 1.4

• Chapter 2 Composition of MySQL Architecture

• • 2.0 Introduction
  • 2.1 MySQL physical file Composition
  • 2.2 MySQL Server System Architecture
  • 2.3 introduction to MySQL built-in tools
  • Conclusion 2.4

• Chapter 2 Introduction to MySQL storage engine

• • 3.0 Introduction
  • 3.1 MySQL storage engine Overview
  • 3.2 introduction to MyISAM storage engine
  • 3.3 introduction to the InnoDB Storage Engine
  • 3.4 NDB Cluster Storage engine Introduction
  • 3.5 introduction to other storage engines
  • Conclusion 3.6

• Chapter 2 MySQL Security Management

• • 4.0 Introduction
  • 4.1 database system security-related factors
  • 4.2 MySQL permission system Introduction
  • 4.3 MySQL Access Authorization Policy
  • 4.4 Security Settings considerations
  • Conclusion 4.5

• Chapter 2 MySQL backup and recovery

• • 5.0 Introduction
  • 5.1 Use Cases of Database Backup
  • 5.2 logical backup and recovery test
  • 5.3 physical backup and recovery test
  • 5.4 backup policy design ideas
  • Conclusion 5.5

2nd Performance Optimization

• Chapter 1 Factors Affecting MySQL Server performance

• • 6.0 Introduction
  • 6.1 impact of business needs on Performance
  • 6.2 Impact of system architecture and implementation on Performance
  • 6.3 impact of Query statements on system performance
  • 6.4 impact of Schema Design on system performance
  • 6.5 impact of hardware environment on system performance
  • Conclusion 6.6

• Chapter 2 MySQL database Locking Mechanism

• • 7.0 Introduction
  • 7.1 Introduction to MySQL Locking Mechanism
  • 7.2 analysis of various locking mechanisms
  • 7.3 use the lock mechanism to optimize MySQL
  • Conclusion 7.4

• Chapter 2 Optimization of MySQL DataBase Query

• • 8.0 Introduction
  • 8.1 understand MySQL Query Optimizer
  • 8.2 basic Query statement optimization ideas and principles
  • 8.3 make full use of Explain and Profiling
  • 8.4 properly design and use Indexes
  • 8.5 Implementation principle and optimization ideas of Join
  • 8.6 optimization of order by, group by, and DISTINCT
  • Conclusion 8.7

• Chapter 2 Performance Optimization of MySQL database Schema design

• • 9.0 Introduction
  • 9.1 efficient model design
  • 9.2 suitable data types
  • 9.3 standard object naming
  • Conclusion 9.4

• Chapter 2? MySQL Server performance optimization

• • 10.0? Introduction
  • 10.1? MySQL installation optimization
  • 10.2? MySQL Log Settings Optimization
  • 10.3? Query Cache Optimization
  • 10.4? Other common MySQL Server Optimizations
  • 10.5? Summary

• Chapter 2? Optimization of common storage engines

• • 11.0? Introduction
  • 11.1? MyISAM storage engine optimization
  • 11.2? InnoDB Storage Engine Optimization
  • 11.3? Summary

3rd? Architecture Design

• Chapter 2? Basic Principles of MySQL scalable design

• • 12.0? Introduction
  • 12.1? What is scalability?
  • 12.2? Principle of minimizing transaction relevance
  • 12.3? Data Consistency Principles
  • 12.4? High Availability and data security principles
  • 12.5? Summary

• Chapter 2? Scalability design-MySQL Replication

• • 13.0? Introduction
  • 13.1? Significance of Replication for the design of scalability
  • 13.2? How Replication works
  • 13.3? Common Replication Architecture
  • 13.4? Build and implement Replication
  • 13.5? Summary

• Chapter 2? Scalable design-data splitting

• • 14.0? Introduction
  • 14.1? What is data splitting?
  • 14.2? Vertical Data splitting
  • 14.3? Horizontal data splitting
  • 14.4? Use of vertical and horizontal joint splitting
  • 14.5? Data splitting and integration solutions
  • 14.6? Possible problems in data splitting and integration
  • 14.7? Summary

• Chapter 2? Scalability design-utilization of Cache and Search

• • 15.0? Introduction
  • 15.1? Database extension with scalable design
  • 15.2? Rational use of third-party Cache Solutions
  • 15.3? Self-implemented Cache service
  • 15.4? Use Search to achieve efficient full-text Search
  • 15.5? High-performance computing of large data volumes using distributed parallel computing
  • 15.6? Summary

• Chapter 2? MySQL Cluster

• • 16.0? Introduction
  • 16.1? MySQL Cluster Introduction
  • 16.2? Create a MySQL Cluster Environment
  • 16.3? MySQL Cluster configuration details (config. ini)
  • 16.4? Basic Management and Maintenance of MySQL Cluster
  • 16.5? Basic optimization ideas
  • 16.6? Summary

• Chapter 2? High Availability design ideas and solutions

• • 17.0? Introduction
  • 17.1? Use Replication to implement high-availability architecture
  • 17.2? Use MySQL Cluster to achieve overall high availability
  • 17.3? Use DRBD to ensure high data security and reliability
  • 17.4? Other high-availability design solutions
  • 17.5? Comparison of advantages and disadvantages of various high availability solutions
  • 17.6? Summary

• Chapter 2? High Availability design-MySQL monitoring

• • 18.0? Introduction
  • 18.1? Monitoring System Design
  • 18.2? Health Status Monitoring
  • 18.3? Performance Status Monitoring
  • 18.4? Common Open Source Monitoring Software
  • 18.5? Summary

• Appendix? Test the Schema creation script

• Appendix B? MySQL system parameter description and setting suggestions

• Appendix C? MySQL status description

The book is eventually as follows:

Original article address: MySQL performance tuning and architecture design is coming soon. Thank you for sharing it with me.