在MySQL中使用NoSQL [英] Use NoSQL in MySQL

问题描述

我注意到MySQL可以将Memcached NoSQL与InnoDB一起使用，但是我无法获取有关如何使用它的信息.

我想与PHP一起使用.

NoSQL查询标准吗?

解决方案

首先，MySQL从5.6版本开始仅支持NoSQL的memcached.今天，此版本尚未在Linux系统信息库中进行更新，必须手动安装，尤其是在服务器中，例如MySQL --version(ubuntu)是5.5.38; (RedHat服务器)5.1

您还必须安装 libevent-dev ，例如:

仍然需要一些技巧，并且您必须为$MYSQL_HOME/share中的MySQL安装内存缓存接口插件.

我找到了一篇解释清楚的帖子，介绍如何安装和尝试: http://chipersoft.com/p/MySQL-via-Memcache/

由于处于年轻状态，因此不适用于生产服务器.

将其与PHP一起使用很容易，因为当您安装php5-cli和php5-memcache时，memcache是​​PHP中的本机模块:

<?php
$memcache = new Memcache;
if (!$memcache->connect('localhost', 11211)) throw new Exception("Could not connect");

if (!$memcache->set('bar', 'John|Smith')) throw new Exception("Could not store value");

$memcache->get('@@aaa'); //switch containers
$result = $memcache->get('AA');

var_dump($result);

结论，此方法可让您同时使用MySQL和NoSQL. Memcache提供了一种快速的NoSQL方式，以一种与SQL完全不同的方式来检索和处理数据.

另一个有用的链接是这个 解决方案

First of all, MySQL only support memcached with NoSQL since version 5.6. Today this version it's not update yet in linux repositories and must be manually installed, specially in servers, e.g. MySQL --version (ubuntu) is 5.5.38 ; (RedHat server) 5.1

You also must install libevent-dev e.g:

Still some hacks are needed, and you must install memcache interface plugin for MySQL located in $MYSQL_HOME/share.

I found a well explained post how to install and try it: http://chipersoft.com/p/MySQL-via-Memcache/

Due to its young state, it's not for production servers.

Use it with PHP is easy because memcache is a native module in PHP when you have php5-cli and php5-memcache installed:

<?php
$memcache = new Memcache;
if (!$memcache->connect('localhost', 11211)) throw new Exception("Could not connect");

if (!$memcache->set('bar', 'John|Smith')) throw new Exception("Could not store value");

$memcache->get('@@aaa'); //switch containers
$result = $memcache->get('AA');

var_dump($result);

Conclusion, this method let you work with MySQL and NoSQL simultaneously. Memcache offers a quick, NoSQL way to retrieve and work with data in a well different manner than SQL.

Edit: Another useful link was this post by Tony Darnell

这篇关于在MySQL中使用NoSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！