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

891 Pages·2009·6.23 MB·English

by  Patrick Galbraith

est. spine=1.78"
Wrox Programmer to ProgrammerTM Wrox Programmer to ProgrammerTM
Developing Web Applications Galbraith
with Apache, MySQL®, memcached, and Perl
Adding a cache layer to the popular LAMP stack is becoming What you will learn from this book
the common solution to significantly reduce the load on back- ● How to install, configure, and work with MySQL particularly
end databases, and also allows for better web application
basic concepts involving data, joins, and indexes as well as mwD
performance. This new caching component is represented by
advanced usage of triggers, stored procedures, user-defined
another “m” in LAMMP, which stands for memcached—a high-
performance, distributed memory object caching system that functions, storage engine usage, and more! eie
provides caching for web applications. The author walks you ● A Perl refresher on basic concepts as well as how to work tv
mh
with data from MySQL using various Perl data types
through the process of using Perl to develop web applications e
both in terms of the front-end display logic as well as the ● A chapter on object-oriented Perl
back-end data retrieval from MySQL and memcached. You ● How to the use Sphinx storage engine for full-text searching cAl
o
also see how to configure the Apache web server to run these as well as Gearman to distribute tasks a
p
mod_perl applications. ● How to install and configure Apache 2.2 to work with p
c
You’ll discover that MySQL and memcached are where the mod_perl 2.0 a
i
data is stored, and Apache is the server that hosts this ● How to use mod_perl handlers to develop web applications, hcn
functionality. You’ll also examine each system while you learn including working with Ajax e
hg
how to install, set up, and administer it. ● A sample search engine application that puts together the
The book shows you how to put each of these systems various technologies discussed in the book de
W
together so you can start building successful applications. ,
Who this book is for ,
Helpful examples put in practice the information covered
This book is for developers who want to write applications using a
throughout the book and a problem-solving chapter offers Me Developing
MySQL, memcached, Apache, and Perl, and are interested in
real-world problems and the process of how you might go n
improving the development process and efficiency. b
about finding a solution to them.
y
d

SA
Web Applications
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, PQ
p
developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They
e
provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. Lp
r
l,® li with Ap ache, MySQL®,
c
a
t memcached, and Perl
i
o
n
www.wrox.com
s

Recommended Database Management ISBN: 978-0-470-41464-4
Computer Book Patrick Galbraith
Categories Web Applications
$49.99 USA
$59.99 CANADA Updates, source code, and Wrox technical support at www.wrox.com
Galbraith cag.tex V2-06/02/2009 11:44am Pageii
Galbraith cag.tex V2-06/02/2009 4:43pm Pagei
Developing Web Applications with Perl,
®
memcached, MySQL and Apache
Foreword ................................................................ xxv
Introduction ............................................................ xxvii
Chapter1:LAMMP,NowwithanExtraM ................................... 1
Chapter2:MySQL......................................................... 15
Chapter3:AdvancedMySQL .............................................. 85
Chapter4:PerlPrimer....................................................163
Chapter5:Object-OrientedPerl...........................................211
Chapter6:MySQLandPerl ...............................................245
Chapter7:SimpleDatabaseApplication ..................................285
Chapter8:memcached ..................................................313
Chapter9:libmemcached ................................................359
Chapter10:MemcachedFunctionsforMySQL ............................383
Chapter11:Apache......................................................417
Chapter12:ContactListApplication .....................................503
Chapter13:mod_perl ....................................................565
Chapter14:Usingmod_perlHandlers.....................................601
Chapter15:Moremod_perl ..............................................633
Chapter16:PerlandAjax ................................................707
Chapter17:SearchEngineApplication ...................................739
AppendixA:InstallingMySQL ............................................793
AppendixB:ConfiguringMySQL ..........................................811
Index ....................................................................831
Galbraith cag.tex V2-06/02/2009 11:44am Pageii
Galbraith ffirs.tex V3-06/03/2009 4:22pm Pageiii
Developing Web Applications with Perl,
memcached, MySQL® and Apache
Patrick Galbraith

WileyPublishing,Inc.
Galbraith ffirs.tex V3-06/03/2009 4:22pm Pageiv
®
Developing Web Applications with Perl, memcached, MySQL and Apache
Publishedby
WileyPublishing,Inc.
10475CrosspointBoulevard
Indianapolis,IN46256
www.wiley.com
Copyright©2009byWileyPublishing,Inc.,Indianapolis,Indiana
PublishedsimultaneouslyinCanada
ISBN:978-0-470-41464-4
ManufacturedintheUnitedStatesofAmerica
10987654321
Nopartofthispublicationmaybereproduced,storedinaretrievalsystemortransmittedinanyformorbyany
means,electronic,mechanical,photocopying,recording,scanningorotherwise,exceptaspermittedunderSections
107or108ofthe1976UnitedStatesCopyrightAct,withouteitherthepriorwrittenpermissionofthePublisher,or
authorizationthroughpaymentoftheappropriateper-copyfeetotheCopyrightClearanceCenter,222Rosewood
Drive,Danvers,MA01923,[phone],fax[phone].RequeststothePublisherforpermissionshouldbe
addressedtothePermissionsDepartment,JohnWiley&Sons,Inc.,111RiverStreet,Hoboken,NJ07030,(201)
748-6011,fax[phone],oronlineathttp://www.wiley.com/go/permissions.
LimitofLiability/DisclaimerofWarranty:Thepublisherandtheauthormakenorepresentationsorwarrantieswith
respecttotheaccuracyorcompletenessofthecontentsofthisworkandspecificallydisclaimallwarranties,including
withoutlimitationwarrantiesoffitnessforaparticularpurpose.Nowarrantymaybecreatedorextendedbysalesor
promotionalmaterials.Theadviceandstrategiescontainedhereinmaynotbesuitableforeverysituation.Thiswork
issoldwiththeunderstandingthatthepublisherisnotengagedinrenderinglegal,accounting,orotherprofessional
services.Ifprofessionalassistanceisrequired,theservicesofacompetentprofessionalpersonshouldbesought.
Neitherthepublishernortheauthorshallbeliablefordamagesarisingherefrom.Thefactthatanorganizationor
Websiteisreferredtointhisworkasacitationand/orapotentialsourceoffurtherinformationdoesnotmeanthat
theauthororthepublisherendorsestheinformationtheorganizationorWebsitemayprovideorrecommendations
itmaymake.Further,readersshouldbeawarethatInternetWebsiteslistedinthisworkmayhavechangedor
disappearedbetweenwhenthisworkwaswrittenandwhenitisread.
ForgeneralinformationonourotherproductsandservicespleasecontactourCustomerCareDepartmentwithinthe
UnitedStatesat(877)762-2974,outsidetheUnitedStatesat(317)572-3993orfax(317)572-4002.
LibraryofCongressControlNumber:2009927343
Trademarks:Wiley,theWileylogo,Wrox,theWroxlogo,WroxProgrammertoProgrammer,andrelatedtradedress
aretrademarksorregisteredtrademarksofJohnWiley&Sons,Inc.and/oritsaffiliates,intheUnitedStatesand

othercountries,andmaynotbeusedwithoutwrittenpermission.MySQLisaregisteredtrademarkofMySQLAB.
Allothertrademarksarethepropertyoftheirrespectiveowners.WileyPublishing,Inc.,isnotassociatedwithany
productorvendormentionedinthisbook.
Wileyalsopublishesitsbooksinavarietyofelectronicformats.Somecontentthatappearsinprintmaynotbe
availableinelectronicbooks.
Galbraith ffirs.tex V3-06/03/2009 4:22pm Pagev
Tomywonderfulwife,Ruth,whomIhaveknownfor27yearsandwhohasstoodbymewhilewriting
thisbook,evenwhenIcouldn’tgiveherthetimeshedeserved.Also,tomydearfriendKrishna,
whogavemeinspirationeveryday.
Galbraith fcre.tex V3-06/02/2009 11:44am Pagevi
Credits
AcquisitionsEditor VicePresidentandExecutiveGroup
JennyWatson Publisher
RichardSwadley
ProjectEditor
MaureenSpears VicePresidentandExecutivePublisher
BarryPruett
TechnicalEditor
JohnBokma AssociatePublisher
JimMinatel
ProductionEditor
RebeccaColeman ProjectCoordinator,Cover
LynseyStanford
CopyEditor
SaraE.Wilson Proofreader
CorinaCopp,WordOne
EditorialManager
MaryBethWakefield Indexer
RobertSwanson
ProductionManager
TimTate
Galbraith fauth.tex V3-06/02/2009 11:46am Pagevii
About the Author
PatrickGalbraithlivesupinthesticksofsouthwesternNewHampshirenearMt.Monadnockwith
hiswife,Ruth.Since1993,hehasbeenusinganddevelopingopensourcesoftware.Hehasworkedon
variousopensourceprojects,includingMySQL,Federatedstorageengine,MemcachedFunctionsfor
MySQL,Drizzle,andSlashcode,andisthemaintainerofDBD::mysql.Hehasworkedatanumberof
companiesthroughouthiscareer,includingMySQLAB,Classmates.com,OSDN/Slashdot.Hecurrently
worksforLycos.Heisalsopartownerofawirelessbroadbandcompany,RadiusNorth,whichprovides
InternetservicetounderservedruralareasofNewHampshire.Hiswebsite,whichcomesbywayofa
5.8GHzAlvarionaccessunitupinapinetree,ishttp://patg.net.
About the Technical Editor
JohnBokmaisaself-employedPerlprogrammerandconsultantfromtheNetherlands.Hehasbeen
working professionally in software development since 1994, moving his primary focus more and
moretowardthe Perlprogramminglanguage. Johnandhis wife,Esmeralda, currently live in the
stateofVeracruz,Mexico,withtheirdaughterAlice. John’sothertwochildren, Jim andLaurinda,
livewiththeirmotherinNewZealand.FormoreinformationortocontactJohn,visithiswebsiteat
http://johnbokma.com/.
Galbraith fauth.tex V3-06/02/2009 11:46am Pageviii