{"version":"1.0","provider_name":"Jui-Nan Lin&#039;s Blog","provider_url":"https:\/\/jnlin.org","author_name":"jnlin","author_url":"https:\/\/jnlin.org\/author\/jnlin\/","title":"MySQL 5.5 \u7684 InnoDB Memcached Plugin","html":"\u4e4b\u524d\u66fe\u7d93\u63d0\u904e <a href=\"http:\/\/jnlin.org\/2011\/03\/26\/474\/\">HandlerSocket - A NoSQL Plugin for MySQL<\/a>\uff0c\u53ef\u4ee5\u900f\u904e\u985e\u4f3c NoSQL \u7684\u65b9\u5f0f\u5b58\u53d6 InnoDB\uff0c\u6548\u80fd\u6703\u6bd4\u666e\u901a SQL \u66f4\u597d\u3002\u5f8c\u4f86 Oracle \u5728 MySQL 5.5 \u63a8\u51fa\u7684\u6642\u5019\uff0c\u76f4\u63a5\u4f7f\u7528 Memcached Protocol\uff0c\u7406\u8ad6\u4e0a\u61c9\u8a72\u662f\u66f4\u65b9\u4fbf\uff08\u56e0\u70ba Memcached Adapter \u5230\u8655\u90fd\u6709...\uff09\u3002\r\n\r\n\u65bc\u662f\u6700\u8fd1\u4ed4\u7d30\u7684\u7814\u7a76\u4e86\u4e00\u4e0b\uff0c\u767c\u73fe\u8981\u4f7f\u7528 MySQL 5.5 \u7684 InnoDB Memcached Plugin\uff0c\u8981\u6ce8\u610f\u4ee5\u4e0b\u7684\u5730\u65b9\uff1a\r\n\r\n<ol>\r\n<li>\u5982\u679c\u8981\u4f7f\u7528\u81ea\u884c\u6307\u5b9a\u7684 Table\uff0c\u9700\u8981\u53c3\u8003 <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/innodb-memcached-internals.html\"> Internals of the InnoDB memcached Plugin<\/a>\uff0c\u5728 <code>innodb_memcache.containers<\/code> \u8a2d\u5b9a key \u8207 column \u7684\u5c0d\u61c9\u8868\u3002<\/li>\r\n<li>\u9810\u8a2d\u662f\u4f7f\u7528 <code>containers<\/code> Table \u88e1\u9762 name \u70ba <code>default<\/code> \u7684 Table\u3002<\/li>\r\n<li>\u5982\u679c\u8981\u6307\u5b9a Table\uff0c\u8981\u5728 GET \u6216 SET \u6307\u4ee4\u524d\uff0c\u4e0b <code>GET @@name<\/code> \u6216 <code>SET @@name<\/code> \u5c07\u4e4b\u5f8c\u7684 Request \u90fd\u5207\u63db\u5230 <code>name<\/code> \u9019\u500b Table\u3002\r\n<\/li><li>\u5982\u679c\u9700\u8981 Replication\uff0c\u8a18\u5f97\u8981\u8a2d\u5b9a <code>innodb_api_enable_binlog<\/code> \u9019\u500b\u503c\u3002<\/li>\r\n<\/ol>\r\n\r\n\u5927\u6982\u91cd\u9ede\u5c31\u9019\u4e9b\u4e86\uff0c\u5982\u679c\u9084\u6709\u73a9\u5230\u5225\u7684\u518d\u4f86\u88dc\u5145\u3002","type":"rich"}