MySQL triggers auto updates memcache

Today saw the lawful website
MYSQL, base that the UDFs, UDFs is the User Defined Functions of the acronym refers to Mysql user-defined functions, applications can use these features from Mysql5.0 above apt way the database alternatively to obtain written Memcached data. In adding, starting from the Mysql5.1 aid triggers, so namely you can use the trigger Memcached UDFs instantly update the content of the applying to dilute the complexity of the chart and prose. Here we briefly introduce the installation and use of UDFs:
1, install Libmemcached (memcached consumer C API)
Download: http://download.tangent.org/
#. / configure prefix = / usr & & make & & make install
Note: Please install above / usr below Otherwise, ascertain the time backward the installation of memcached_functions_mysql, but likewise clarify PKG_CONFIG_PATH,Supra Skylow Shoes, trouble.
2, install memcached_functions_mysql
Download: http://download.tangent.org/
#. / configure with-mysql = / usr / local / mysql / bin / mysql_config
installation is complete, you absence to duplicate the library files libmemcached_functions_mysql mysql / lib catalogue under the plugin directory.
# cp / usr / local / lib / libmemcached_functions_mysql * / usr / regional / mysql / lib / plugin /.
# shell> mysql SELECT memc_servers_set ('192 .168.0.1:11211,192.168.0.2:11211 ');
establish a test table:
mysql> create chart test3 (
-> id int (3) not null,
-> name varchar (64) no null default
create trigger
mysql> DELIMITER |
-> CREATE TRIGGER test3_insert
-> BEFORE INSERT ON test3
-> FOR EACH ROW BEGIN
-> SET @ mm = memc_set (concat ('id:', NEW.id), NEW.name) ;
-> END |
can discern the official website: http://dev.mysql.com/doc/refman/5.1/en/ha-memcached-interfaces-mysqludf.html
Postscript: I consider it ought be a write operation scenario is not frequent, but the query is quite massive site, memcache is not out of the storage database data, the time when the database changes,Supra Shoes UK, the use of mysql's insert, update ,Supras, erase triggers to change the memcached server data. Mysql data type of operation but does not support orders,Supra Bullet Shoes, memc_set ought not support the thing or an array of other data types. A tiny tough to appliance.
proceeded in mind: MYSQL UDF OF JSON
trial based on the above thoughts, I think there should UDF data rows can be converted into json format data, so that really can not access the database front-end the idea was, GOOGLE What a good object, google really found after: UDF Repository as MySQL, the open source morale is really a foreigner:), this is a MYSQL UDF library site, I found as json inside the udf.
Download: http://www.mysqludf.org/lib_mysqludf_json/lib_mysqludf_json_0.0.2.tar.gz
Installation:
# mkdir udf_of_json
# cd udf_of_json
; # wget http://www.mysqludf.org/lib_mysqludf_json/lib_mysqludf_json_0.0.2.tar.gz
# tar zxvf lib_mysqludf_json_0.0.2.tar.gz
# cp. / lib_mysqludf_json.so / usr / local / mysql / lib / plugin /.
# mysql-u root
mysql> source. / lib_mysqludf_json.sql
test:
DELIMITER | |
CREATE TRIGGER user_insert
AFTER INSERT ON users
FOR EACH ROW BEGIN
SELECT json_array (username, user_type , real_name, password,Supra Trainers, spirited, last_login, detailing) into @ user_info FROM consumers where user_id = NEW.user_id;
SET @ mm = memc_set (concat ('user_info_',Supra Vaider Shoes, NEW.user_id), @ user_info);
END | |
It also supports Chinese folk actually are elated, but does not support multi-line set, whether I use cached program or a custom function to write it. Study. . . .