I'm biased, but I think the best and most succinct writing about this is the introductory "What is mod_perl" on take23. I think it should cover everything you need to know.