MySQL Administrators Bible

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.

Spis treści:
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 Tu ning.
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.

Okładka tylna:

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.