lua_package_path "/path/to/lua-resty-mysql/lib/?.lua;;";

server {
location /ssi {
content_by_lua '
local mysql = require "resty.mysql"
local db, err = mysql:new()
if not db then
ngx.say("failed to instantiate mysql: ", err)
return
end
db:set_timeout(1000) -- 1 sec
local ok, err, errcode, sqlstate = db:connect{
path = "/path/to/mysql.sock",
database = "ngx_test",
user = "ngx_test",
password = "ngx_test"}
if not ok then
ngx.say("failed to connect: ", err, ": ", errcode, " ", sqlstate)
return
end
ngx.say("connected to mysql.")
local res, err, errcode, sqlstate = db:query("select * from cats order by id asc", 10)
if not res then
ngx.say("bad result: ", err, ": ", errcode, ": ", sqlstate, ".")
return
end
';
}
}






const COUNTERS = likes, dislikes, visits, comments


local mysql = require "resty.mysql"
local db, err = mysql:new()
if not db then
  ngx.log(ngx.ERR, "failed to instantiate mysql: ", err)
  return
end

local ok, err, errno, sqlstate = db:connect{
  host = "127.0.0.1",
  port = 3306,
  database = "lua",
  user = "lua",
  password = "lua",
  max_packet_size = 1024 * 1024
}
if not ok then
  ngx.log(ngx.ERR, "failed to connect: ", err, ": ", errno, ": ", sqlstate)
  return
end

if index then
--
end

res, err, errno, sqlstate =
db:query("UPDATE post SET visits = visits + 1 WHERE id = ???")
if not res then
  ngx.log(ngx.ERR, "bad result: ", err, ": ", errno, ": ", sqlstate)
  return
end


if not кеш?? then
res, err, errno, sqlstate =
db:query("SELECT COUNTERS FROM post WHERE id = 1")
if not res then
  ngx.log(ngx.ERR, "bad result: ", err, ": ", errno, ": ", sqlstate, ".")
  return
end
В мемкеш!
end

ngx.say("counter: " .. res[1]["value"])

local ok, err = db:set_keepalive(10000, 100)
if not ok then
  ngx.log(ngx.ERR, "failed to set keepalive: ", err)
  return
end