Skip to content

MySQL Administrator's Bible

ISBN-10: 0470416912

ISBN-13: 9780470416914

Edition: 2009

Authors: Keith Murphy, Sheeri K. Cabral, Cabral

List price: $50.00
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an intermediate level DBA transitioning from another database platform. The book is divided into two parts---Part 1 covers the fundamentals of MySQL database management, including MySQL's unique approach to such basic database features/functions as SQL queries, data and index types, stored procedures and functions,, triggers and views, and transactions. The authors briefly explain each topic in terms of general database management practices, and then drill down into how they work in a MySQL environment.Part 2 provides comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible---these include: MySQL Server Tuning Query Processing, including authentication and optimization Managing storage engines Caching Backup and Recovery Managing users Partitioning Replication and logging Index tuning Database and performance monitoring Security Managing availability and scalingAppendixes will include a tutorial on basic, foundational SQL programming that all MySQL DBAs need to understand (and often don't), plus reference resources. The companion website will provide code examples, scripts,and data schemas used in the book.
Customers also bought

Book details

List price: $50.00
Copyright year: 2009
Publisher: John Wiley & Sons, Limited
Publication date: 5/8/2009
Binding: Paperback
Pages: 888
Size: 7.25" wide x 9.25" long x 2.00" tall
Weight: 3.410
Language: English

Introduction
Introduction to MySQL
Installing and Upgrading the 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, Recovery and Disaster Planning
User Management
Partitioning
Logging and Replication
Measuring Performance
Query Analysis and Index Tuning
Monitoring Your Systems
Securing MySQL
MySQL Data Dictionary
Scaling and High Availability Architectures
MySQL Proxy
Functions and Operators
Resources
Index