作者:Sheeri K. Cabral, Keith Murphy
出版日期:May 11, 2009
出版社:Wiley Publishing
页数:888
ISBN:ISBN-10: 0470416912 ISBN-13: 978-0470416914
文件格式:PDF
Product Description
With special focus on the next major release of MySQL, this resourceprovides a solid framework for anyone new to MySQL or transitioningfrom another database platform, as well as experience MySQLadministrators. The high-profile author duo provides essential coverageof the fundamentals of MySQL database management—including MySQL’sunique approach to basic database features and functions—as well ascoverage of SQL queries, data and index types, stores procedure andfunctions, triggers and views, and transactions. They also presentcomprehensive coverage of such topics as MySQL server tuning, managingstorage engines, caching, backup and recovery, managing users, indextuning, database and performance monitoring, security, and more.From the Back Cover
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 frameworkfor a beginning MySQL DBA or an experienced DBA transitioning fromanother database platform. The book starts with the fundamentals ofMySQL database management, including MySQL’s unique approach to SQLqueries, data and index types, stored procedures and functions,triggers and views, and transactions. The authors continue withcomprehensive coverage of major MySQL Server components and processesfor which DBAs are responsible—these include:
MySQL Server tuningQuery optimization and index tuningManaging storage enginesCachingAuthentication and managing usersPartitioning; Replication; LoggingDatabase and performance monitoringSecurity; Backup and RecoveryManaging availability and scalingFully covers MySQL 5.1Companion Web Site
The book’s Companion Web Site includes a tutorial on foundationalSQL programming that all MySQL DBAs need to understand, plus codeexamples, scripts, and data schemas used in the book. You’ll also learnabout the latest changes in MySQL and find helpful links. Visit thesite at www.wiley.com/go/mysqladminbible.