node-db-cache
for nodejs db cache module
require
node -v >7.10
need open --harmony
what is?
Separation based on mysql and redis database,
reading and writing of distributed and the second level cache function
How To Use?
for example
-first open your mysql and your redis; sql into mysql:
; IF EXISTS `test`.`user`;.`user` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`uid`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;INSERT INTO `user` VALUES ('1', 'zs');INSERT INTO `user` VALUES ('2', 'ls');INSERT INTO `user` VALUES ('3', 'ww');INSERT INTO `user` VALUES ('4', 'hehe');
-second
mkdir -p testcd testnpm install db-cachevim test.js
input:
var config = db: use:'mysql' mysql : master: host : "127.0.0.1" user : "root" password : "123456" port : "3306" database : 'test' slaves: host : "127.0.0.1" user : "root" password : "123456" port : "3306" database : 'test' host : "127.0.0.1" user : "root" password : "123456" port : "3306" database : 'test' // middleData:{ // use :'mongodb', // mongodb:{ // host : "127.0.0.1", // port:"27017", // } // }, cache: use:'redis' redis : host : "127.0.0.1" port : "6379" // password : "", db : 0 host : "127.0.0.1" port : "6379" // password : "", db : 0 ; var dbCache = ;var DBCacheEngine = dbCacheDBCacheEngine;var BaseModule = dbCacheBaseModule;var enigine = DBCacheEngine; { superengine'user'cacheIdisCache; } async var res = await this; return res; var res = this; return res; //you can use uid as cacheIdvar uid = 1;var user = enigineuidtrue;// user.getUser(1);// user.getUser(1);// user.updateUser(1);user;
-third node --harmony test.js
you can see(first):
[ RowDataPacket { uid: 1, name: 'zs1' } ]
then command+c,double time to exit,then run "node --harmony test.js" again:
you can see(again,now in cache):
[ { uid: 1, name: 'zs1' } ]