MySQL Administrator’s Bible

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Table of Contents

Part I: First Steps with MySQL
Chapter 1: Introduction to MySQL
Chapter 2: Installing and Upgrading MySQL Server
Chapter 3: Accessing MySQL

Part II: Developing with MySQL
Chapter 4: How MySQL Extends and Deviates from SQL
Chapter 5: MySQL Data Types
Chapter 6: MySQL Index Types
Chapter 7: Stored Routines, Triggers, and Events
Chapter 8: MySQL Views
Chapter 9: Transactions in MySQL

Part III: Core MySQL Administration
Chapter 10: MySQL Server Tuning
Chapter 11: Storage Engines
Chapter 12: Caching with MySQL
Chapter 13: Backups and Recovery
Chapter 14: User Management
Chapter 15: Partitioning
Chapter 16: Logging and Replication
Chapter 17: Measuring Performance

Part IV: Extending Your Skills
Chapter 18: Query Analysis and Index Tuning
Chapter 19: Monitoring Your Systems
Chapter 20: Securing MySQL
Chapter 21: The MySQL Data Dictionary
Chapter 22: Scaling and High Availability Architectures

Appendix A: MySQL Proxy
Appendix B: Functions and Operators
Appendix C: Resources