MySQL Administrator's Bible

Front Cover
John Wiley & Sons, Mar 4, 2011 - Computers - 888 pages
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.

What people are saying - Write a review

We haven't found any reviews in the usual places.


First Steps with MySQL
Developing with MySQL
MySQL Data Types
MySQL Index Types
Stored Routines Triggers and Events
Measuring Performance
Extending Your Skills
Securing MySQL
Data Security
Creating Security Policies
The MySQL Data Dictionary

MySQL Views
Transactions in MySQL
Core MySQL Administration
Storage Engines
Caching with MySQL
Backups and Recovery
User Management
MySQL User Privileges
Logging and Replication
MySQL Proxy
Transactions in MySQL
Connection Pooling
Basic Proxy Script Behavior
MySQL Proxy Constants
MySQL Proxy Internal Structures
Functions and Operators
Functions and Operators
How MySQL Extends and Deviates from

Other editions - View all

Common terms and phrases

About the author (2011)

Sheeri K. Cabral won the MySQL Community Member of the Year award in 2007 and 2008. She organizes the Boston, Massachusetts, USA, MySQL User Group -- which she founded in November 2005 -- and produces freely available presentation videos as well as OurSQL: The MySQL Database Podcast for the Community, by the Community. You can check out her prolific blog postings at

Keith Murphy is a MySQL database administrator who has been using MySQL server since 1998. He recently formed Paragon Consulting Services ( to provide consulting services for companies seeking MySQL training and help with MySQL solutions ranging from everyday database administration tasks to utilizing "cloud" computing services, performance tuning and scaling. Keith blogs at in addition he is the editor of MySQL Magazine ( Readers are invited to contact Keith by email at

Bibliographic information