MySQL Administrator's Bible
Published on 8. May 2009
Book
Paperback/Softback
888 pages
978-0-470-41691-4 (ISBN)
Description
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.
More details
Product info
WebSite Associated w/Book
Series
Edition
1. Auflage
Language
English
Place of publication
New York
United States
Target group
Professional and scholarly
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 47 mm
Weight
1626 gr
ISBN-13
978-0-470-41691-4 (9780470416914)
Schweitzer Classification
Other editions
Additional editions
Sheeri K. Cabral | Keith Murphy
MySQL Administrator's Bible
E-Book
03/2011
Wiley
€48.99
Available for download
Sheeri K. Cabral | Keith Murphy
MySQL Administrator's Bible
E-Book
04/2009
Wiley
€48.99
Available for download
Persons
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 www.technocation.org.
Keith Murphy is a MySQL database administrator who has been using MySQL server since 1998. He recently formed Paragon Consulting Services (www.paragon-cs.com) 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 blog.paragon-cs.com in addition he is the editor of MySQL Magazine (www.mysqlzine.net). Readers are invited to contact Keith by email at bmurphy@pargon-cs.com.
Keith Murphy is a MySQL database administrator who has been using MySQL server since 1998. He recently formed Paragon Consulting Services (www.paragon-cs.com) 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 blog.paragon-cs.com in addition he is the editor of MySQL Magazine (www.mysqlzine.net). Readers are invited to contact Keith by email at bmurphy@pargon-cs.com.
Content
Introduction.
1. Introduction to MySQL.
2. Installing and Upgrading the MySQL Server.
3. Accessing MySQL.
4. How MySQL Extends and Deviates From SQL.
5. MySQL Data Types.
6. MySQL Index Types.
7. Stored Routines, Triggers and Events.
8. MySQL Views.
9. Transactions in MySQL.
10. MySQL Server Tuning.
11. Storage Engines.
12. Caching with MySQL.
13. Backups, Recovery and Disaster Planning.
14. User Management.
15. Partitioning.
16. Logging and Replication.
17. Measuring Performance.
18. Query Analysis and Index Tuning.
19. Monitoring Your Systems.
20. Securing MySQL.
21. MySQL Data Dictionary.
22. Scaling and High Availability Architectures.
Appendix A. MySQL Proxy.
Appendix B. Functions and Operators.
Appendix C. Resources.
Index.