MySQL Enterprise Solutions

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.

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.