My last post explained what to expect from memcached plugin in
MySQL 5.6 (labs
release). But I want to take a step back and think about
"why" first. Why is memcached plugin of interest at all? What can
I gain from using this instead of plain SQL?
First: I don't see this as a replacement for memcached. If you
want memory caching with memcached then use memcached.
But the memcached plugin to MySQL is a replacement or addition to
the SQL interface to MySQL. So instead of using SQL queries in
your application to persist or retrieve data from MySQL you can
use the memcached interface. And what are the benefits?
- Much higher performance
- Easier scalability via sharding
- Simpler application coding
1. PerformancePerformance is always good. But there are two
different aspects of performance: Latency (or runtime) of a
specific query …