Synopses & Reviews
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.
Review
“…a good read for anyone considering a serious use for MySQL…”(Linux Format, August 2003)
Synopsis
- With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems
- Gives corporate users a complete guide to building enterprise-level database applications with MySQL
- Covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server
- Written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL
- Companion Web site includes all code examples as well as links to useful online resources
About the Author
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.
Table of Contents
Acknowledgments.
About the Author.
Introduction.
PART I. BRINGING MYSQL INTO YOUR ENTERPRISE.
Chapter 1. Overview of MySQL.
Chapter 2. Selecting a Platform for MySQL Server.
Chapter 3. Installing MySQL.
Chapter 4. Testing Your MySQL Installation.
Chapter 5. Access Control and Security.
PART II. DEVELOPING MySQL APPLICATIONS.
Chapter 6. Choosing the Client Language and Client-Server Network Architecture.
Chapter 7. MySQL Client in a Web Environment.
Chapter 8. C/C++ Client Basics.
Chapter 9. PHP Client Basics.
Chapter 10. Perl Client Basics.
Chapter 11. Java Client Basics.
Chapter 12. Writing the Client for Optimal Performance.
PART III. MAINTAINING AND OPTIMIZATION.
Chapter 13. Table Design.
Chapter 14. Configuring the Server for Optimal Performance.
Chapter 15. Analyzing and Improving Server Performance.
Chapter 16. Replication.
Chapter 17. Backup and Table Maintenance.
Chapter 18. 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.
Index.