Just simplify the follow. For each request, application get an id from redis(using incr command), and store id to Mysql in other module. When redis is down, application need get latest id from Mysql and reset it in redis, to make sure no id is duplicated when created from redis for anytime.
Thanks, Linbo 在 2013年7月26日星期五UTC+8下午7时27分05秒，Alan Hoffmeister写道： > > https://gist.github.com/alanhoff/6088166 > > 1 - It will depends on how your driver is configured. > 2 - Use cache to avoid performance issue. > -- > Att, > Alan Hoffmeister > > > 2013/7/26 linbo liao <[email protected] <javascript:>>: > > Hi All, > > > > A simple question, I use nodejs for HTTP restful API service. Now I want > > query some mysql data before http server start, the code snippet: > > > > var price = -1; > > var userId = 'some user provided value'; > > var sql = 'SELECT max(price) FROM users WHERE id = ' + > > connection.escape(userId); > > connection.query(sql, function(err, results) { > > price = results.price; > > }); > > > > server = http.createServer(function (request, response) { > > handler(request); //response depend on price > > }).listen(8012); > > > > Here are two solution to combine mysql query and http server code. > > > > 1. put http server in query callback. Will it cause Mysql keep connect > > during http server running? If Mysql disconnect (usually after 8 hours), > > application works fine? > > > > 2. put query in every request, which cause Mysql query each time for > every > > request, maybe performance issue. > > > > Any other suggestion for this situation? > > > > Thanks, > > > > Linbo > > > > > > > > -- > > -- > > Job Board: http://jobs.nodejs.org/ > > Posting guidelines: > > https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines > > You received this message because you are subscribed to the Google > > Groups "nodejs" group. > > To post to this group, send email to [email protected]<javascript:> > > To unsubscribe from this group, send email to > > [email protected] <javascript:> > > For more options, visit this group at > > http://groups.google.com/group/nodejs?hl=en?hl=en > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "nodejs" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to [email protected] <javascript:>. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
