log by lua mysql_使用Nginx lua把日志实时存储到mysql

准备材料

Nginx.1.12安装包 (下载http://nginx.org/en/download.html)

Lua 相关包

LuaJIT (下载 http://luajit.org/download.html)

ngx_devel_kit (下载 https://github.com/simpl/ngx_devel_kit/tags)

ngx_lua (下载 https://github.com/openresty/lua-nginx-module/tags)

pcre (下载 https://sourceforge.net/projects/pcre/files/pcre/)

lua_mysql (下载 https://github.com/openresty/lua-resty-mysql)

安装

LuaJIT 安装

tar zxf LuaJIT-2.0.5.tar.gz

cd LuaJIT-2.0.5

make

make install PREFIX=/home/myself/lj2

pcre 安装

tar -zxvf pcre-8.32.tar.gz

cd pcre-8.32

make

make install

Nginx 安装

export LUAJIT_LIB=/path/to/luajit/lib

export LUAJIT_INC=/path/to/luajit/include/luajit-2.1

./configure --prefix=/opt/nginx \

--with-ld-opt="-Wl,-rpath,/path/to/luajit-or-lua/lib" \

--add-module=/path/to/ngx_devel_kit \

--add-module=/path/to/lua-nginx-module

make

make install

配置文件

user root;

worker_processes 2;

events {

worker_connections 1024;

}

http{

lua_package_path "/home/oicq/guomm/nginx_lua/lua-resty-mysql-master/lib/?.lua;;"; --重要

lua_share