MySQL Administrator's Bible
- 13h 29m
- Keith Murphy, Sheeri Cabral
- John Wiley & Sons (US)
- 2009
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.
About the Authors
Sheeri K. Cabral is a Database Team Lead at the Pythian Group, a remote database administration solution. She has a master's degree in computer science specializing in databases from Brandeis University and a career background in systems administration. Unstoppable as a volunteer and activist since she was 14, Sheeri founded and organizes the Boston MySQL User Group. She also produces OurSQL: The MySQL Database Podcast for the Community, By the Community and many workshop videos. These resources are freely available at technocation.org, the website of Technocation, Inc. Sheeri is the Treasurer of Technocation, Inc, a not©\for©\profit organization providing resources and educational grants for IT professionals.
Keith Murphy is a MySQL database administrator who has been using MySQL server since 1998. A long©\time Linux system administrator, he worked with a number of Internet companies solving systems issues. More recently he formed Paragon Consulting Services (paragon©\cs.com) to provide consulting services for companies seeking training for MySQL and help with MySQL solutions ranging from everyday database administration tasks to utilizing ¡°cloud¡± computing services, performance tuning, and scaling. In addition to information about the company, Keith blogs at blog.paragon©\cs.com, which he updates as frequently as possible with tricks, tips, and general information about MySQL server.
In addition he is the editor of MySQL Magazine (mysqlzine.net), the MySQL community's digital magazine about all things MySQL. It is his pleasure to work with some of the finest people in the community in this collaborative effort to increase both the amount and quality of the available information on MySQL server.
In this Book
-
Introduction to MySQL
-
Installing and Upgrading MySQL Server
-
Accessing MySQL
-
How MySQL Extends and Deviates from SQL
-
MySQL Data Types
-
MySQL Index Types
-
Stored Routines, Triggers, and Events
-
MySQL Views
-
Transactions in MySQL
-
MySQL Server Tuning
-
Storage Engines
-
Caching with MySQL
-
Backups and Recovery
-
User Management
-
Partitioning
-
Logging and Replication
-
Measuring Performance
-
Query Analysis and Index Tuning
-
Monitoring Your Systems
-
Securing MySQL
-
The MySQL Data Dictionary
-
Scaling and High Availability Architectures
