Developing Web Applications with Apache, MySQL, memcached, and Perl

891 Pages·2009·5.4 MB·English

by  Patrick Galbraith

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