I started writing technical books on MySQL performance optimization and architecture design.

At the invitation of the blog point of view, I recently started to write a technical book on MySQL performance optimization and Architecture Design (the title is not yet determined ), taking into account the features of the simple entry of MySQL database and the fact that the English version of the basic user operation manual already exists, the content of this book will be positioned in the advanced MySQL technology, suitable for MySQL has a basic

At the invitation of the blog point of view, I recently started to write a technical book on MySQL performance optimization and Architecture Design (the title is not yet determined ), taking into account the features of the simple entry of MySQL database and the fact that the English version of the basic user operation manual already exists, the content of this book will be positioned in the advanced MySQL technology, suitable for MySQL has a basic

At the invitation of the blog point of view, I recently started to write a technical book on MySQL performance optimization and Architecture Design (the title is not yet determined ), taking into account the features of the simple entry of MySQL database and the fact that the English version of the basic user operation manual already exists, the content of this book will be positioned in the advanced MySQL technology, it is suitable for readers who have a basic understanding of MySQL, software system architects, and new technology selection decision makers. Of course, it is more appropriate for full-time/part-time Database administrators.

Based on my personal technical expertise and Bowen viewpoint, I have communicated the survey results with relevant technical staff of various Internet companies and the readers of blog posts. The tentative outline of this book is as follows:

I. Basics
1. Basic Introduction to MySQL
1.1 MySQL Server Introduction
1.2 simple comparison between MySQL and other databases
1.3 Main application scenarios of MySQL
Conclusion 1.4
2. MySQL Architecture
2.1 MySQL physical file Composition
2.2 MySQL Server System Architecture
2.3 introduction to MySQL built-in tools
2.4 introduction to third-party MySQL tools
Conclusion 2.5
3. MySQL storage engine Introduction
3.1 Introduction to MyISAM
3.2 introduction to Innodb
3.3 introduction to NDB Cluster
3.4 other storage engines
Conclusion 3.5


Ii. Maintenance
4. MySQL Security Policy Management
4.1 database system security-related factors
4.2 Access Authorization Policy
4.3 System Security Settings
4.4 code-related security factors
Conclusion 4.5
5. Routine basic MySQL Maintenance
5.1 table maintenance
5.2 index Maintenance
5.3 log Maintenance
Conclusion 5.4
6. MySQL Backup Recovery
6.1 backup policy design
6.2 logical backup and recovery test
6.3 physical backup and recovery test
Conclusion 6.4

Iii. Optimization
7. Factors affecting MySQL Server performance
7.1 impact of system architecture on database performance
7.2 impact of SQL statements on database performance
7.3 impact of database Schema design on database performance
7.4 impact of software and hardware environment on database performance
Conclusion 7.5
8. MySQL database application system design
8.1 business needs rationalization
8.2 System Architecture Optimization
8.3 logic implementation simplified
Conclusion 8.4
9. MySQL database Locking Mechanism
9.1 Introduction to MySQL Lock Mechanism
9.2 comparison of lock mechanisms of various storage engines
9.3 use the lock mechanism to optimize MySQL
Conclusion 9.4
10. MySQL Query statement Performance Optimization
10.1 basic principles of Query statement Optimization
10.1 properly design and use Indexes
10.2 Optimization of Join
10.3 transaction Optimization
10.4 other common Optimization Methods and Techniques
Conclusion 10.5
11. MySQL Server Optimization
11.1 MySQL Server installation optimization
11.1 Query Cache Optimization
11.2 log settings Optimization
11.3 network and connection Optimization
11.4 Optimization of other common MySQL Server Settings
Conclusion 11.5
12. Optimization of common storage engines
12.1 MyISAM storage engine optimization
12.2 InnoDB Storage Engine Optimization
12.3 NDB Cluster Optimization
Conclusion 12.4

Iv. Architecture
13. scalability Design
13.1 utilization of replication technology
13.2 principles of transaction relevance
13.3 data splitting Design
13.4 proper use of external Cache
Conclusion 13.5
14. High Availability design
14.1 use asynchronous replication to avoid basic spof
14.2 use NDB Cluster for real-time synchronous Replication
14.3 use DRBD for real-time synchronization of non-shared storage
14.4 other high-availability design solutions
14.5 comparison of advantages and disadvantages of various high availability solutions
Conclusion 14.6
15. MySQL Server System Monitoring
15.1 Monitoring System Design
15.2 running status monitoring
15.3 Performance Status Monitoring
Conclusion 15.4

Appendix
A ,? Set up an experiment and test environment
A.1 MySQL Server installation overview
A.2 set up the runtime environment required for various experiment examples in this book
B ,? MySQL parameters and status
B .1 MySQL system parameter description and setting suggestions
B .2 description and analysis of MySQL status

The book focuses on the optimization of Article 3 (overall performance optimization) and article 4 (high-availability scalable architecture design, the first and second articles have a relatively small amount of content, especially the first one, which is generally a simple introduction and will not be studied in depth.

The above outline is only the current draft, not the final version. some adjustments may be made as the preparation progresses. If you have any comments or suggestions on the outline, you can leave a message here or mail it directly to me (sky000 # gmail.com). I will take every suggestion from every friend seriously. Thank you!

Original article address: I started writing technical books on MySQL performance optimization and architecture design. Thank you for sharing with me.