By Baron Schwartz
Excessive functionality MySQL is the definitive consultant to development speedy, trustworthy platforms with MySQL. Written by means of famous specialists with years of real-world adventure construction very huge structures, this booklet covers each point of MySQL functionality intimately, and makes a speciality of robustness, defense, and information integrity.
High functionality MySQL teaches you complicated concepts intensive so that you can carry out MySQL's complete energy. tips on how to layout schemas, indexes, queries and complex MySQL gains for max functionality, and get exact suggestions for tuning your MySQL server, working approach, and to their fullest power. you will additionally examine sensible, secure, high-performance how one can scale your functions with replication, load balancing, excessive availability, and failover.
This moment version is totally revised and tremendously multiplied, with deeper insurance in all components. 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
• results of latest positive aspects in MySQL 5.0 and 5.1, together with kept methods, partitioned databases, triggers, and views
• a close dialogue on how you can construct very huge, hugely scalable platforms with MySQL
• New concepts for backups and replication
• Optimization of complex querying positive factors, akin to full-text searches
• 4 new appendices
The publication additionally contains chapters on benchmarking, profiling, backups, protection, and instruments and strategies that can assist you degree, video display, and deal with your MySQL installations.