Welcome! Log In Create A New Profile

Advanced

Re: Rewrite lookup via MySQL table

August 30, 2010 06:38AM
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@gmail.com> wrote:
> On Sat, Aug 28, 2010 at 8:54 PM, relix <nginx-forum@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@nginx.org
> http://nginx.org/mailman/listinfo/nginx
>

_______________________________________________
nginx mailing list
nginx@nginx.org
http://nginx.org/mailman/listinfo/nginx
Subject Author Posted

Rewrite lookup via MySQL table

btafoya August 23, 2010 08:22PM

Re: Rewrite lookup via MySQL table

mike August 23, 2010 08:28PM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 10:20PM

Re: Rewrite lookup via MySQL table

Piotr Sikora August 23, 2010 08:46PM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 11:40PM

Re: Rewrite lookup via MySQL table

mike August 23, 2010 11:44PM

Re: Rewrite lookup via MySQL table

agentzh August 24, 2010 12:00AM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 12:03AM

Re: Rewrite lookup via MySQL table

mike August 24, 2010 12:16AM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 11:46PM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 12:05AM

Re: Rewrite lookup via MySQL table

agentzh August 24, 2010 12:06AM

Re: Rewrite lookup via MySQL table

agentzh August 25, 2010 01:54AM

Re: Rewrite lookup via MySQL table

relix August 28, 2010 08:54AM

Re: Rewrite lookup via MySQL table

agentzh August 29, 2010 11:26PM

Re: Rewrite lookup via MySQL table

bvidinli August 30, 2010 06:38AM

Re: Rewrite lookup via MySQL table

bvidinli August 30, 2010 06:38AM

Re: Rewrite lookup via MySQL table

relix August 30, 2010 09:04AM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 02:27PM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 02:41PM

Re: Rewrite lookup via MySQL table

mike August 25, 2010 01:14AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 78
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready