SaraDaddy

MySQL Administrators Bible With Lessons Files

Authors :  Sheeri K. Cabral,Keith Murphy
Publisher : Wiley
1st Edition
Date : May 11, 2009
Language : English
Included Lessons Files
PDF Format
Pages : 888
Size : 14,49 Mb

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.

Whether you're a novice or experienced DBA, this book has all you need to learn MySQL

MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an experienced DBA transitioning from another database platform. The book starts with the fundamentals of MySQL database management, including MySQL's unique approach to SQL queries, data and index types, stored procedures and functions, triggers and views, and transactions. The authors continue with comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible—these include:

MySQL Server tuning

Query optimization and index tuning

Managing storage engines

Caching

Authentication and managing users

Partitioning; Replication; Logging

Database and performance monitoring

Security; Backup and Recovery

Managing availability and scaling

Fully covers MySQL 5.1

Companion Web Site

The book's Companion Web Site includes a tutorial on foundational SQL programming that all MySQL DBAs need to understand, plus code examples, scripts, and data schemas used in the book. You'll also learn about the latest changes in MySQL and find helpful links. Visit the site at www.wiley.com/go/mysqladminbible.

https://www.filefactory.com/file/46qygo9m3uhz/