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