On: MySQL now includes memcached, and a plugin that al...

[andrewcooke]

is it clear how this works? i can't work out what a memcache query would look like. is the key that SQL select statement as a string?

[crazygringo → andrewcooke]

It's just a memcache API call.

It doesn't even go over the SQL interface, it's not text-based.

[andrewcooke → crazygringo]

so there's no cross-use at all? it's just a memcache api implementation that happens to be implemented in the same software package as mysql?

[rada → andrewcooke]

This part of the manual lists several advantages as compared to simply packaging MySQL and memcached together, the first two probably being the most significant.

http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-bene...

[andrewcooke → rada]

thanks. so the advantage seems to be that it's persistent (and in a way that's integrated with existing mysql system mgmt for backups etc).