Wrox Programmer Forums
BOOK: Expert PHP and MySQL
This is the forum to discuss the Wrox book Expert PHP and MySQL by Andrew Curioso, Ronald Bradford, Patrick Galbraith; ISBN: 9780470563120
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert PHP and MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 16th, 2010, 05:19 AM
Registered User
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs down Chapter 5 deprecated

I'm reading this fantastic book but I'm having some problems with the chapter 5, "memcache and MySQL".

I think the approach described in this chapter is very usefull especially when you're creating complex application with a huge amount of memcache keys; in an consistent application you want that cached objects referencing to older information previously saved in a MySQL table have to be immediately deleted from the memcache, preserving the overall data coherence.
This task could be easly done with a simple trigger in MySQL where, each time you remove a row from a table automatically the trigger send a memc_delete() call to the memcache server, specify the key of the cached element to remove.

Right now the only problems seems to be the MySQL plugin described in this chapter; infact the memcached-udfs project is out of maintenance and is not possible to compile this plugin in an updated enviroment with the last libmemcached (I'm using the 0.40 but the same problems seems to be affected in older version).
It seems like the source point to deprecated functions/variables name and also fixing that from the source code, when you try to import and install the memcached-udfs functions in the MySQL server some pointing errors are displayed, making impossible the use of this library.

In the project page there are a lots of bug reported but right now nobody try to fix those and make this library updated.

I think this is a big issue especially in a new book released just a couple of months ago.
Old June 16th, 2010, 11:18 AM
Registered User
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hi there - thanks for letting me know about that. I need to get out a new release of the UDFs.

Also, another way to make sure you delete items accordingly is to use expiry times for items that you want refreshed more often, or whenever you perform any write action (insert, delete, update), make sure to do the same with memcached.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ulysses Framework contains deprecated code nebular BOOK: Professional PHP6 1 June 7th, 2010 09:35 AM
Call-time pass-by-reference has been deprecated tusharkale Beginning PHP 0 October 9th, 2007 09:32 AM
Chapter 17, p.568, "Style", deprecated attributes irish_songbird BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 0 October 22nd, 2006 08:41 PM
GenericDataSource Deprecated lizethfc JSP Basics 0 June 5th, 2003 11:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.