MySQL administrator's bible / Sheeri Cabral, Keith Murphy.

Format:

Book

Author/Creator:

Cabral, Sheeri, 1978-

Contributor:

Murphy, Keith, 1970-

Language:

English

Subjects (All):

Database management.

Relational databases.

MySQL (Electronic resource).

Physical Description:

1 online resource (891 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Wiley Pub., 2009.

Language Note:

English

System Details:

text file

Summary:

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,

Contents:

MySQL® Administrator's Bible; About the Authors; Credits; Acknowledgments; Contents at a Glance; Contents; Introduction; Who Should Read This Book; How This Book Is Organized; What's on the Companion Website; Where To Go From Here; Part I: First Steps with MySQL; Chapter 1: Introduction to MySQL; Chapter 2: Installing and Upgrading MySQL Server; Chapter 3: Accessing MySQL; Part II: Developing with MySQL; Chapter 4: How MySQL Extends and Deviates from SQL; Chapter 5: MySQL Data Types; Chapter 6: MySQL Index Types; Chapter 7: Stored Routines, Triggers, and Events; Chapter 8: MySQL Views

Chapter 9: Transactions in MySQLPart III: Core MySQL Administration; Chapter 10: MySQL Server Tuning; Chapter 11: Storage Engines; Chapter 12: Caching with MySQL; Chapter 13: Backups and Recovery; Chapter 14: User Management; Chapter 15: Partitioning; Chapter 16: Logging and Replication; Chapter 17: Measuring Performance; Part IV: Extending Your Skills; Chapter 18: Query Analysis and Index Tuning; Chapter 19: Monitoring Your Systems; Chapter 20: Securing MySQL; Chapter 21: The MySQL Data Dictionary; Chapter 22: Scaling and High Availability Architectures; Appendix A: MySQL Proxy

Appendix B: Functions and OperatorsAppendix C: Resources; Index

Notes:

Includes bibliographical references and index.

Includes index.

Description based on metadata supplied by the publisher and other sources.

ISBN:

9786612122217

9781118080580

1118080580

9781282122215

1282122215

9780470506615

047050661X

OCLC:

437122693