Rewrite lookup via MySQL table

[bvidinli]

I am new to nginx,
bug, as far as I know,
nginx is known to be a fast light webserver.

So, having each rewrite to be looked up in a mysql table seems
something very slow idea.
rewrite is something to be done on the fly, as fast as possible. and
putting a mysql layer in this process seems not a good idea.


On Mon, Aug 30, 2010 at 6:20 AM, agentzh <agentzh at gmail.com> wrote:
> On Sat, Aug 28, 2010 at 8:54 PM, relix <nginx-forum at nginx.us> wrote:
>> First of all, this thread contains a lot of information! I'm in the
>> process of implementing something similar and it has helped me a ton.
>>
>> I was just wondering, as long as you're using Lua anyway, why not do
>> away with Drizzle completely, and just make Lua connect to the database
>> to retrieve the correct URL?
>
> Lua's database library will block the nginx process which is
> unacceptable for real world applications. ngx_drizzle is served as a
> non-blocking mysql driver component for Lua here (of cause, it can
> also work with ngx_http_js_module and others).
>
>> Is it because Drizzle will keep one
>> connection to the database per nginx-instance, so there is less
>> overhead,
>
> Actually ngx_drizzle can keep connection pools to mysql backends per
> nginx instance. One db connection per process is the suboptimal
> PHP/Perl way of doing things and it can waste a lot of database
> resources.
>
>> compared to Lua which would have to connect and disconnect to
>> the database for every request?
>>
>
> MUCH more than just that ;)
>
> Cheers,
> -agentzh
>
> _______________________________________________
> nginx mailing list
> nginx at nginx.org
> http://nginx.org/mailman/listinfo/nginx
>