mysql drizzle_nginx高效mysql访问模块drizzle安装和使用

2012年07月17日

nginx, mysql, drizzle, 性能优化, 高效

nginx高效mysql访问模块drizzle安装和使用

1.编译安装 libdrizzle-1.0

http://agentzh.org/misc/nginx/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

2.下载drizzle-nginx-module

wget https://github.com/chaoslawful/drizzle-nginx-module/tarball/v0.1.2rc7 -O chaoslawful-drizzle-nginx-module-v0.1.2rc7-0-g272cabf.tar.bz2

3.下载rds-json-nginx-module

wget https://github.com/agentzh/rds-json-nginx-module/tarball/v0.12rc10 -O agentzh-rds-json-nginx-module-v0.12rc10-0-g74c21b3.tar.gz

4.编译安装tengine

./configure –prefix=/server/tengine –with-file-aio –with-http_lua_module –with-http_ssl_module –with-http_stub_status_module –with-http_sub_module –with-pcre –add-module=../chaoslawful-drizzle-nginx-module-272cabf –add-module=../agentzh-rds-json-nginx-module-74c21b3

make && sudo make install

5.配置

>http节点下:

upstream cluster {

drizzle_server 127.0.0.1:3306 dbname=mysql password=liangwei user=root protocol=mysql;

}

>server节点下:

location /mysql {

set $my_sql 'select * from user';

drizzle_query $my_sql;

drizzle_module_header off;

drizzle_pass cluster;

rds_json on;

}

6.简单的压力测试:

liangwei@liangwei-ubuntu:/server/tengine/conf$ webbench -t 20 -c 10000 http://192.168.56.101/mysql

Webbench – Simple Web Benchmark 1.5

Copyright (c) Radim Kolar 1997-2004, GPL Open Source Software.

Benchmarking: GET http://192.168.56.101/mysql

10000 clients, running 20 sec.

Speed=82350 pages/min, 7930495 bytes/sec.

Requests: 26978 susceed, 472 failed.

liangwei@liangwei-ubuntu:/server/tengine/conf$ webbench -t 20 -c 10000 http://192.168.56.101/index.php

Webbench – Simple Web Benchmark 1.5

Copyright (c) Radim Kolar 1997-2004, GPL Open Source Software.

Benchmarking: GET http://192.168.56.101/index.php

10000 clients, running 20 sec.

Speed=48501 pages/min, 4362751 bytes/sec.

Requests: 16167 susceed, 0 failed.

7.错误解决

>1)./configure: error: SSL modules require the OpenSSL library.

apt-get install libssl-dev

>2)./configure: error: ngx_http_lua_module requires the Lua library.

apt-get install liblua5.1-0-dev