Expert MySQL, Second Edition

Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must read book for all systems integrators, engineers, and software developers working with the MySQL server code.

Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-read book for anyone doing high-end work involving MySQL.

• Shows how to customize MySQL and its storage and authentication engines
• Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting
• Covers high-end features such as high-availability and replication

What you’ll learn

• Learn the inner workings of MySQL
• Diagnose and improve poorly performing queries
• Implement high-availablity solutions and replication
• Modify and debug the server code
• Build your own pluggable storage engines and authentication modules
• Implement new SQL functions and syntax
• Build your own query optimizer

About the Author

Charles Andrew Bell works for Oracle Corporation and is a senior member of the MySQL engineering team. He is the team lead for MySQL Utilities and has over eight years’ experience in developing the MySQL server. He lives in a small town in rural Virginia with his loving wife, and received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. His research interests include database systems, versioning systems, semantic web, and agile software development.

Dr. Bell’s research projects and development of an advanced database versioning system make him uniquely qualified to author this book. He is an expert in the database field and has extensive knowledge and experience in modifying the MySQL source code. With over 25 years’ experience in enterprise development and systems architecture, his experience provides him excellent insight into developing and modifying open source systems.