I have complex objects where the keys are made up of attributes from multiple tables and i want our memcached servers to be updated when the mysql tables are updated, inserted, deleted. I am trying to find the best strategy for this.
The main problem is that updates are sometimes done via mysql commands i.e we don't have a CRM for every update to the database therefore i really like the idea of the MySQL udf's. However i would think it would be fairly slow to join 4 tables (1 table has 60, 000 users, 2nd table has 10 countries, 3rd table has 10 cultures, 4th table is the actual item that has been updated = 6000000 keys) and run the memc_delete() function. I was thinking about using a flush for some of the updates because they would happen so irregularly (i.e once a month) that no one would really notice. I have also looked at namespaces which would be a great idea but doesn't look like getting implemented for a variety of reasons. Does anyone else have a good strategy for managing complex keys
