MySQL Enterprise Solutions

Alexander Sasha Pachev

416 pages, parution le 18/03/2003

Ajouter à une liste

Indisponible

Résumé

Learn how to build and manage enterprise-level MySQL applications

With more than three million users, MySQL is the most popular open source database server in the world. In addition to running on Linux, Windows, Macintosh, FreeBSD, and several flavors of UNIX, MySQL provides an extremely fast, reliable, and inexpensive alternative to such commercial databases as Oracle, DB2, and Informix. Advantages such as those have convinced corporations to adopt MySQL to replace their more expensive database servers.

Written by Alexander Pachev, one of the lead programmers of MySQL, MySQL Enterprise Solutions is the first book to provide corporate users with both advice for adopting MySQL and a complete guide to building enterprise-level database applications with MySQL. Pachev covers all of the major programming languages used with MySQL, each illustrated with code examples. In addition, he includes case studies that document how enterprise customers are successfully using MySQL.

This informative guide also covers such topics as:

The pros and cons of a company adopting MySQL
How to select the best platform for MySQL
Installing, testing, and configuring the MySQL server
Optimizing MySQL server performance
Migrating to MySQL from other commercial databases
Security, access control, and backup
Practical guidance on trouble-shooting in a business environment

The companion Web site includes all of the code for the databases included in this book.

Contents

Part I. Bringing MySQL Into Your Enterprise

Overview of MySQL
Selecting a Platform for MySQL Server
Installing MySQL
Testing Your MySQL Installation
Access Control and Security

Part II. Developing MySQL Applications

Choosing the Client Language and Client-Server Network Architecture
MySQL Client in a Web Environment
C/C++ Client Basics
PHP Client Basics
Perl Client Basics
Java Client Basics
Writing the Client for Optimal Performance

Part III. Maintaining and Optimization

Table Design
Configuring the Server for Optimal Performance
Analyzing and Improving Server Performance
Replication
Backup and Table Maintenance
Exploring MySQL Server Internals

Part IV. Appendices

Appendix A: Migration Notes
Appendix B: Troubleshooting Notes
Appendix C. SQL Problem Solving Notes
Appendix D. Online Resources

L'auteur - Alexander Sasha Pachev

Alexander SASHA PACHEV has worked for MySQL AB since December 1999, and is the primary developer responsible for creating some of the enterprise-level features in MySQL. He has written sections of the MySQL documentation, including those on replication. Pachev has also been part of the MySQL AB support team and handled numerous support requests from corporate MySQL users. He has spoken at MySQL and open source conferences, and has written several freeware Linux packages.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Alexander Sasha Pachev
Parution	18/03/2003
Nb. de pages	416
Format	18,5 x 23,4
Couverture	Broché
Poids	610g
Intérieur	Noir et Blanc
EAN13	9780471269229
ISBN13	978-0-471-26922-9