The new book, "MySQL King of the Road" published!

This book is divided into seven parts from the knowledge structure.
The 1th part of the stubborn bronze (chapter 1th to 8th). Includes MySQL profile, mainstream branch version, database installation/Startup/shutdown, rights Management, memory pool structure of MySQL database, storage engine, threading action, refresh mechanism, database file, table management, character set, statistics and data defragmentation methods. It also includes a detailed interpretation of the index, an analysis of the execution plan, the presentation of the stress test, a presentation of the transaction, and an in-depth explanation of the isolation level and learning with the lock.

Part 2nd Order Silver (chapter 9th). Describes commonly used backup methods, logical backups, and bare file backups in a production environment. The principles of Mysqldumpmysqldump, Select...into outfile, Mydumper and Xtrabackup and other backup recovery tools are detailed and practiced.

Part 3rd honors the Golden Chapter (10th to 11th). This paper introduces the principle of master-slave copying, explains the copying parameters in detail, explains the comprehensive interpretation and practice of the semi-synchronous replication, multi-source replication, Gtid replication, and introduces the verification and replication management techniques of replication data consistency, and interprets various error faults in master-slave replication.

Part 4 Premium Platinum (chapter 12th to 15th). Introduction to the Internet mainstream MySQL high-availability cluster architecture. MHA, keepalived, PXC Principles of analysis, maintenance management and practice. Finally, this paper introduces Proxysql's application of this powerful MySQL intermediate agent layer.

The 5th part of the Eternal Diamond Chapter (chap. 16th to 17th). This article introduces the new features of the MySQL5.7 version, and introduces the optimization of MySQL database through the four dimensions of hardware, operating system, database and program design.

The 6th part of the Supreme Star Yao (chapter 18th to 19th). Learn to deploy Lepus and monitor MySQL and version upgrades.

The 7th part of the strongest king of the 20th chapter. MySQL Interview summary.

Address of book Purchase:
Lao Zhang's Database Micro store

The new book, "MySQL King of the Road" published!