preface
MySQL is a typical representative of open source database. It has a mature ecosystem and has outstanding performance in reliability, performance and ease of use. Its development has witnessed the rise and fall and growth of the Internet.
In a DeveloperWeek survey, more than three out of five respondents used SQL, with MySQL topping the charts with 38.9% usage, It was followed by MongoDB(24.6%), PostgreSQL (17.4%), Redis (8.4%) and Cassandra (3.0%). There is no doubt that the open source technology ecosystem, dominated by MySQL, is becoming more popular.
With the ever-changing requirements of customers and the increasingly reliable and secure network environment, enterprises continue to release the ability to “multiply innovation”, which means that the digital transformation from the IT era to the DT era. Faced with a large amount of data and business, more companies have realized the importance of data value. How to manage and make good use of data has become more and more important, and MySQL is in the vanguard among them.
\
This book is an advanced note on the skills of a front-line MySQL DBA, which condenses the author’s database management experience for many years. From operations management, architecture, optimization and operational development three aspects, drawing carefully screened the author summed up in the actual work skills, handling method of common problems and for the operational system of thinking and practice: especially operational development section from 0 to 1 build a operational system, able to DBA stack existing knowledge and skills to achieve a new comb. The core idea of this book is that “the advancement of skills promotes the transformation of thinking”. The value of this book lies in allowing readers to thoroughly understand the author’s approach to solving problems in this book. This book aims to help DBA with some MySQL database management experience to master the practical skills of management operation and maintenance, and to understand the principles of the database through the knowledge points.
directory
\
Content abstract
The book is divided into three chapters, a total of 15 chapters, a comprehensive introduction to database management, architecture and SQL optimization, operation and maintenance development related work content, in these knowledge points are also interspersed with a large number of examples.
The first chapter (Chapters 1-5) introduces the development, technology selection and architecture of MySQL in detail. It takes the operation and maintenance scenario as the starting point to restore the daily management work of DBA by sorting out SQL development specifications and summarizing operation and maintenance management practices.
Chapter 1 MySQL development and technology selection
\
Chapter 2 understands the MySQL architecture
\
Chapter 3 Basic operation and maintenance of MySQL
\
Chapter 4 SQL development specification and foundation
\
Chapter 5 MySQL operation and maintenance management practice
\
The second part (chapters 6 to 10) covers SQL query optimization, concurrency control, and performance testing on this foundation. The MySQL high availability architecture and cluster related content are supplemented on, and the architecture design ideas based on business are provided.
Chapter 6 MySQL Query Optimization
\
Chapter 7 MySQL Transactions and locks
\
Chapter 8 MySQL Cluster and high availability Design
\
Chapter 9 MySQL Performance Test
\
Chapter 10 database architecture design based on business
\
The third chapter (Chapter 11~15) contains the construction idea of the entire operation and maintenance development system from 0 to 1, including operation and maintenance development foundation, architecture design and planning, operation and maintenance management module design, self-service design and other parts.
Chapter 11 Operation and maintenance development basis
\
Chapter 12 Automatic operation and maintenance architecture design and planning
\
Chapter 13 MySQL operation and maintenance infrastructure design
\
Chapter 14 design of MySQL operation and maintenance management module
\
Chapter 15 Self-service operation and maintenance service
\
MySQL DBA Worknotes database management, architecture optimization and operations development (DBA
Access to:
Experts recommend
\
This article is shared from wechat official number – May Heaven have no BUG (MA214617). If there is infringement, please contact [email protected] to delete. This article participates in “OSC source innovation Program”, welcome you to join us and share with us.