Developing Web Applications with Apache, MySQL, Memcached, and Perl (Wrox Programmer to Programmer) (Paperback)

• Developers use Apache, MySQL, memcached, and Perl to build dynamic Web sites that store information within the MySQL database; this is the only book to address using these technologies together to alleviate the database load in Web development
• Covers each of the four systems and shows how to install, set up, and administer them; then shows the reader how to put the parts together to start building applications
• Explains the benefits of a base perl library for code re–use, and provides sample applications that demonstrate in a practical way the information covered in the previous chapters
• Examines monitoring, performance, and security, with a problem–solving chapter that walks the reader through solving real–world issues

You′ll discover that MySQL and memcached are where the data is stored, and Apache is the server that hosts this functionality. You′ll also examine each system while you learn how to install, set up, and administer it.

The book shows you how to put each of these systems together so you can start building successful applications. Helpful examples put in practice the information covered throughout the book and a problem–solving chapter offers real–world problems and the process of how you might go about finding a solution to them.

What you will learn from this book

• How to install, configure, and work with MySQL particularly basic concepts involving data, joins, and indexes as well as advanced usage of triggers, stored procedures, user–defined functions, storage engine usage, and more!
• A Perl refresher on basic concepts as well as how to work with data from MySQL using various Perl data types
• A chapter on object–oriented Perl
• How to the use Sphinx storage engine for full–text searching as well as Gearman to distribute tasks
• How to install and configure Apache 2.2 to work with mod—perl 2.0
• How to use mod—perl handlers to develop web applications, including working with Ajax
• A sample search engine application that puts together the various technologies discussed in the book

Who this book is for
This book is for developers who want to write applications using MySQL, memcached, Apache, and Perl, and are interested in improving the development process and efficiency.

Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.