Syncing Percona MySql Database Changes to Caching Tier
We're deploying Couchbase as a caching solution for our web application. We're looking for a reliable manner to synchronize changes to the database (Percona MySQL) to the caching tier. This could be done in the application tier; however, this leads to the potential for stale records (in case of failure between transaction commit and sync to couchbase) or potential cache updates made before a transaction completes. We have done some cursory exploration of UDF capabilities to solve this problem using a trigger. Do you have a recommendations or experience with other customers solving this problem?
The most obvious solution would be to use Couchbase for persistence instead of MySQL. Can you tell us why you're keeping Percona MySQL?
Having said that, it seems there are MySQL plugin for Memcache. Have you try them?