SQL. Часть 4
Эти книги помогут тебе освоить SQL: gонимание устройства работы СУБД на низком уровне, понимание деталей работы дисковых движков, знание кодовой базы СУБД, владение навыками конфигурации и использование кластерных СУБД (например Galera), участие в разработке opensource СУБД.
High Performance MySQL: Optimization, Backups, and Replication Third Edition
Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
UNDERSTANDING MYSQL INTERNALS
Sasha Pachev
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.
Sasha Pachev
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.