Original link: https://102no.com/2023/06/05/high-performance-mysql-4/

I wrote an article in the column “10 MySQL must-read books recommended” before, and the one with the widest audience and the most read is “High Performance MySQL”. It’s four editions. I think it was the second or third edition when I bought this book. The biggest update of this edition is to embrace the new version, update the introduction of a large number of new features of MySQL 5.7 and 8.0, and delete many obsolete functions of the old version. Also added some enterprise-level, architecture-class MySQL enhancement skills.

new chapter

The whole book is about half thinner than the third edition, and the number of chapters has also changed from 16 to 13 chapters. The chapters “Extending MySQL”, “MySQL in the Cloud”, and “MySQL Compliance” have been added, regardless of depth. There are more in-depth introductions in both breadth and breadth, and even at the end of the book, I even used a very short space to guide “MySQL on Kubernetes”.

MySQL in the cloud

The chapter “MySQL in the Cloud” closely follows the current cloud trend. The book directly introduces the MySQL products “Amazon Aurora for MySQL” and “GCP Cloud SQL” of the world’s largest cloud service provider. It is very direct and concise to introduce the process of cloud database, precautions, trade-off computing hardware consumption, understand the performance measurement indicators of cloud database, and some other necessary guidelines for cloud.

Scalability

This chapter of “Scalability” talks about how MySQL responds to the high-speed growth of traffic and the complexity of high-speed growth data requirements; from which different dimensions to expand, how to expand, how to expand from reading and writing, what are the Tools can assist with scaling, consider periodic models for scaling, and more. These issues must be considered when doing initial architecture design and long-term operation and maintenance.

Compliance

Now information security has become a link that major Internet manufacturers must attach great importance to. “MySQL Compliance” focuses on this part. In addition to information security compliance, it also introduces how to build this compliance control system, such as Information management, data separation, log tracking. This important link is basically introduced from the perspective of enterprise-level data management, so from the perspective of enterprise technology managers, learning this part is also essential.

After reading the fourth edition of “High Performance MySQL”, the biggest feeling is that the previous editions gradually guide you from development and DBA entry to an in-depth understanding of using MySQL. This edition has a wider field of vision and a higher standpoint. If you want to go further towards junior architects and CTOs and increase your knowledge of database breadth, this book is also worth reading. Of course, if it is for introductory understanding, in-depth study, or as a reference book, the third edition + fourth edition will be a perfect match.

This article is transferred from: https://102no.com/2023/06/05/high-performance-mysql-4/
This site is only for collection, and the copyright belongs to the original author.