Developing Web Applications with Apache, MySQL, memcached, and Perl
Adding a cache layer to the popular LAMP stack is becoming the common solution to significantly reduce the load on back-end databases, and also allows for better web application performance. This new caching component is represented by another "m" in LAMMP, which stands for memcached - a high-performance, distributed memory object caching system that provides caching for web applications. The author walks you through the process of using Perl to develop web applications both in terms of the front-end display logic as well as the back-end data retrieval from MySQL and memcached. You also see how to configure the Apache web server to run these mod_perl applications. more »
Professional Website Performance
Effective website development requires optimum performance with regard to both web browser and server. This book covers all aspects of building and maintaining websites that deliver peak performance on all levels. Exploring both front-end and back-end configuration, it examines factors like compression and JavaScript, database performance, MySQL tuning, NoSQL alternatives, load-balancing across multiple servers, effective caching of web contents, CSS, and much more. Both developers and system administrators will find value in this platform-neutral guide. more »
Learning MySQL
Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season? more »
PHP and MySQL For Dummies, 3rd Edition
Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way(r) to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more. more »
Pro MySQL
Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. more »
The Definitive Guide to MySQL 5, 3rd Edition
Whether you're a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.

MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, 3rd Edition is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the world's most popular open source database server. more »
MySQL Administrator's Bible
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management - including MySQL's unique approach to basic database features and functions-as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more. more »
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail. more »
Expert MySQL, 2nd Edition
Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code. more »
PHP5 and MySQL Bible
This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine. Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL. Offers an extensive tutorial for developing applications with PHP and MySQL. Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions. The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience. more »