Pro MySQL

Build powerful MySQL-driven applications with detailed coverage of advanced SQL optimization, stored procedures, profiling, replication, and more

Michael Kruckenberg, Jay Pipes - Collection The Expert's Voice in Open Source

734 pages, parution le 29/09/2005

Ajouter à une liste

Indisponible

Résumé

MySQL's meteoric rise in the database market has drawn considerable attention as organizations look toward cost-effective yet powerful solutions to their data warehousing needs. Yet effectively designing, deploying, and managing an enterprise database requires you to go beyond the basics and master the advanced features and techniques that will ultimately prove crucial to your project's success. This book provides you with the answers you've been searching for.

The text is divided into two parts. Part One, Design and Development, covers key enterprise-level MySQL concepts such as transaction processing and indexing theory, benchmarking and profiling, and advanced topics pertinent to storage engines and data types. We also delve into the MySQL source code and system architecture-at a level you won't find anywhere else. We'll test your SQL skills regarding subqueries, derived tables, and join topics, and investigate scenarios ranging from how to effectively deal with hierarchical data to performing Geographic Information Systems calculations. Finally, you'll learn all about the bevy of features new to MySQL 5, including stored procedures, views, triggers, and more.

Part Two, Administration, covers administrative topics including MySQL installation, user administration, database backups, and MySQL replication for high-availability systems. This part also includes a chapter on installing, configuring, and maintaining a MySQL cluster, and a chapter on the new data dictionary features of MySQL 5.

L'auteur - Michael Kruckenberg

Michael Kruckenberg started his career with web technologies more than 10 years ago. His first major undertaking was bringing a small mail-order company online (using MySQL). After hopping around a bit during the 1990s Internet boom and spending time in the Internet startup world, Mike put his feet down at his current gig, senior programmer at Tufts University. He is now the technical manager for the Apache/Perl/MySQL-driven Tufts University Sciences Knowledgebase (TUSK), a content repository for faculty and students. Mike likes to spend his elusive free time with his wife and kids on New England adventures, has a healthy addiction to music, and likes to dabble in the arts (photography, video, and literature).

L'auteur - Jay Pipes

For the past 10 years, Jay Pipes has worked with all kinds of companies, large and small, to identify the value of the information they collect and help them build software that best addresses the needs of their businesses. From e-commerce to work-order management systems, Jay has been involved in projects with both Microsoft and open-source technologies. Passionate about programming and all things technical, Jay now runs his own consulting business, based in Columbus, Ohio. When not being bothered by his two cats, two dogs, and a constantly ringing phone, you can find him, headphones pulled across his ears, happily coding away at home.

Sommaire

Foreword
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Design and Development
- Analyzing Business Requirements
- Index Concepts
- Transaction Processing
- MySQL System Architecture
- Storage Engines and Data Types
- Benchmarking and Profiling
- Essential SQL
- SQL Scenarios
- Stored Procedures
- Functions
- Cursors
- Views
- Triggers
Administration
- MySQL Installation and Configuration
- User Administration
- Security
- Backup and Restoration
- Replication
- Cluster
- Troubleshooting
- MySQL Data Dictionary
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Michael Kruckenberg, Jay Pipes
Collection	The Expert's Voice in Open Source
Parution	29/09/2005
Nb. de pages	734
Format	17,5 x 23,5
Couverture	Broché
Poids	1182g
Intérieur	Noir et Blanc
EAN13	9781590595053
ISBN13	978-1-59059-505-3