High Performance MySQL: Optimization, Backups, Replication, and More

High Performance MySQL: Optimization, Backups, Replication, and More

Baron Schwartz, Arjen Lentz

High functionality MySQL is the definitive advisor to construction quick, trustworthy platforms with MySQL. Written by means of famous specialists with years of real-world event development very huge structures, this ebook covers each point of MySQL functionality intimately, and makes a speciality of robustness, protection, and information integrity. High functionality MySQL teaches you complicated innovations extensive so that you can convey out MySQL's complete strength. tips on how to layout schemas, indexes, queries and complicated MySQL gains for optimum functionality, and get certain suggestions for tuning your MySQL server, working procedure, and to their fullest capability. you will additionally study sensible, secure, high-performance how you can scale your purposes with replication, load balancing, excessive availability, and failover. This moment variation is totally revised and significantly extended, with deeper insurance in all parts. significant additions include:

  • Emphasis all through on either functionality and reliability
  • Thorough insurance of garage engines, together with in-depth tuning and optimizations for the InnoDB garage engine
  • Effects of recent gains in MySQL 5.0 and 5.1, together with saved techniques, partitioned databases, triggers, and perspectives
  • A targeted dialogue on the right way to construct very huge, hugely scalable structures with MySQL
  • New concepts for backups and replication
  • Optimization of complex querying good points, resembling full-text searches
  • Four new appendices

The ebook additionally contains chapters on benchmarking, profiling, backups, protection, and instruments and methods that will help you degree, visual display unit, and deal with your MySQL installations.

Show sample text content

Download sample