Open or not open, that is the stupid question.

Memcaced is a good solution for scale out your system. And there is a project for MySQL udf by implement memcached. Prepare libmemcached: # wget http://download.tangent.org/libmemcached-0.37.tar.gz # export PKG_CONFIG_PATH=/usr/local/lib/pkgconfig # ./configure --with-mysql=/usr/local/mysql/bin/mysql_config # make && make install PS. when I use libmemcached 0.38 and complie source, I get a error like below: # wget http://download.tangent.org/memcached_functions_mysql-0.8.tar.gz servers.c: In function 'memc_servers_set': servers.c:122: error: 'memcached_st' has no member named 'hosts' servers.c:123: error: 'memcached_st' has no member named 'hosts' servers.c:124: error: 'memcached_st' has no member named 'hosts' But after down-grade the version from 0.38 to 0.37 then works. Compile memcahced function: # wget http://download.tangent.org/memcached_functions_mysql-0.8.tar.gz # tar zxvf ./ memcached_functions_mysql-...

If you don't know what memcached is, please refer to the link here . 1. Download the source from official website. http://memcached.org/ 2. Unzip/Untar the source. # gzip -cd ./memcached-1.4.4.tar.gz | tar xvf - 3. Configure source/Make/Make install. # cd ./memcached-1.4.4 # ./configure # make && make install PS. In my environment, when I configure the source, the error message show up, and told me that the memcached need libevent. If you have the same problem, just download it from here . And compile it by yourself. And I create a symbolic link for libevent. # ln -s /usr/local/lib/libevent-1.4.so.2 /lib64/ libevent-1.4.so.2 4. Start memcached. # vi /etc/memcached.conf                                    ## memcached configuration file # memcached -l 127.0.0.1 -P 11211 -m 128 -d`   ## fo...