Hi!
I got for my birthday the new book from Wrox – Expert PHP and MySQL by Andrew Curioso, Ronald Bradford and Patrick Galbraith.
“This book examines some of the technologies and techniques needed to make robust and scalable applications perform in today’s high-demand world” (From the Introduction of the book..).
In this book you can learn about:
- Advanced MySQL concepts [Stored Procedures, different drivers and Storage Engines, Views, Triggers, Replications]
- PHP Opcode Cache with APC or eAccelerator
- PHP Caching techniques – Memcached
- Multi Tasking in PHP and MySQL with Gearman
- and more…
This book is for developers who had worked on several projects and have some good experience developing with PHP and MySQL and developers whom develop high-demand applications, or applications that handles lots of data and processing. OOP experience recommended.
What I really enjoyed reading in this book is about
- Gearman – a tool you install in you server and assign jobs [from your client] to those job server. For example – creating thumbnails of the photos your users upload, the thumbnail process done by different server [has Gearman installed and maybe even better for this kind of job] and this allows you to reduce the load on your client server (= faster application).
- Memcached – Memcached is a “High-performance distributed memory objects caching system”, it provides key=>value cache for your applications to reduce the load on your database. Basically, in uses the free memory in your server and uses this to cache objects of your application. its really simple to work with Memcached and it has lots of performance benefits.
- APC/eAccelerator – Each time you run php script the PHP compiler compiles your code again and again. In production environment the code isn’t changing that much, APC and eAccelerator [different tools] allows you to cache the compiled code, this way the server isn’t compiling the same code again and you get better performance. In PHP6 will have APC extension natively.
The techniques discussed in this book used by large sites we all know: Digg, Yahoo, Facebook, YouTube and more.. if its good for them I believe its good for you too 
[...] Available in stores this now. Pick up your copy today on Amazon.com. What other people are saying: For once, an “Expert” book where you not only can, but must take the title seriously. Carsten Pedersen The techniques discussed in this book [are] used by large sites we all know: Digg, Yahoo, Facebook, YouTube and more.. if its [sic] good for them I believe its good for you too. Udi Mosayev [...]
Expert PHP and MySQL | Andrew's Tech Musings
4 Jun 10 at 08:27
in uses the free memory in your server and uses this to cache objects of your application. its really simple to work with Memcached and it has lots of performance benefits.
laptop battery
17 Aug 10 at 06:52