http {
  #gzip  on;
  listen 80;

 upstream backend {
     drizzle_server 127.0.0.1:3306 dbname=test1
          password=Secret123  user=root  protocol=mysql;
 }

server {
    listen       80;
    server_name  localhost;

    location /f{
       drizzle_pass backend;
       drizzle_module_header off;
       drizzle_query "select * from cats"; #$query_string;
       rds_json on;
    }
   }
}

wget https://openresty.org/download/drizzle7-2011.07.21.tar.gz
tar xzvf drizzle7-2011.07.21.tar.gz
cd drizzle7-2011.07.21/
./configure --without-server
make libdrizzle-1.0
make install-libdrizzle-1.0
cd ..
git clone https://github.com/openresty/drizzle-nginx-module.git
git clone https://github.com/openresty/rds-json-nginx-module.git
wget -c https://openresty.org/download/openresty-1.11.2.1.tar.gz
tar zxvf openresty-1.11.2.1.tar.gz
cd openresty-1.11.2.1

./configure
--with-pcre=../pcre-$PCREVER
--with-zlib=../zlib-$ZLIBVER
--with-sha1=/usr/include/openssl
--with-md5=/usr/include/openssl
--with-http_stub_status_module
--with-http_secure_link_module
--with-luajit
--with-pcre-jit
--with-http_auth_request_module
--with-http_addition_module
--with-http_gunzip_module
--with-http_image_filter_module
--with-http_dav_module
--with-http_flv_module
--with-http_gzip_static_module
--with-http_realip_module
--with-http_stub_status_module
--with-http_ssl_module
--with-http_sub_module
--with-http_xslt_module
--with-ipv6
--add-module=..rds-json-nginx-module
--add-module=..drizzle-nginx-module