Download PDF MySQL Enterprise Solutions by Alexander “Sasha” Pachev

Sinopsis

MySQL has penetrated the enterprise in a way that perhaps would be odd for a typical proprietary application, but is very common for an open-source package. Developers brought it in through the back door, and sometimes by the time management found out, developers had a working solution based on MySQL with zero database licensing costs. This often won acceptance for MySQL at both the management and development levels.
 

Some prominent users of MySQL have publicly released the fact that they are using MySQL and somewhat elaborated on their use, which allows us to talk about them in this book. Others are using it in production frequently under heavy load but treat this information as a trade secret. The organizations I mention in this section have made their use of MySQL public, so we can discuss a few details about their implementations. The companies listed here are the tip of the iceberg.
 

MySQL AB collects user stories and publishes them at www.mysql.com/ press/user_stories/, so you might want to check there for more information.

Content

1.  Bringing MySQL into Your Enterprise
2. Overview of MySQL
3. Selecting a Platform for MySQL Server
4. Installing MySQL
5. Testing Your MySQL Installation
6. Access Control and Security
7. Developing MySQL Applications
8. Choosing the Client Language and Client-Server Network Architecture
9. MySQL Client in a Web Environment
10. C/C++ Client Basics
11. PHP Client Basics
12. Perl API Basics
13. Java Client Basics
14. Writing the Client for Optimal Performance
15. Maintaining and Optimization
16. Table Design
17. Configuring the Server for Optimal Performance
18. Analyzing and Improving Server Performance
19. Replication
20. Backup and Table Maintenance
21. Exploring MySQL Server Internals

Click here to download