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
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
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 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse