Welcome! Log In Create A New Profile

Advanced

Re: DB Relay - NGiNX based open source project

Piotr Sikora
July 22, 2010 07:04PM
Hi Brian,

> Yes, it is blocking currently. That will be fixed, I've been working
> on the upstream version, just not ready yet.

Please note that just by using ngx_http_upstream_* you won't make it
magically non-blocking, you'll also need non-blocking C libraries
(libdrizzle for MySQL, freetds for SQL Server) and you'll need to use the
non-blocking interfaces (which you don't use right now)... That means that
for MySQL you'll be better off by building on top of ngx_drizzle.

> ngx_drizzle and ngx_postgres weren't around at the time we started
> development

Ah, OK... That would explain it :)

> (I'm looking at ways to build on them if possible since
> they do now exist).

It's almost* possible right now, to be honest you can "implement" dbrelay
using ngx_form_input combined with ngx_drizzle/ngx_postgres.

* almost, because by design neither ngx_drizzle nor ngx_postgres allow you
to specify database login and password on the run-time.

Best regards,
Piotr Sikora < piotr.sikora@frickle.com >



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

DB Relay - NGiNX based open source project

Vlad Didenko July 22, 2010 05:54PM

Re: DB Relay - NGiNX based open source project

mike July 22, 2010 06:02PM

Re: DB Relay - NGiNX based open source project

Brian Bruns July 22, 2010 06:14PM

Re: DB Relay - NGiNX based open source project

mike July 22, 2010 06:24PM

Re: DB Relay - NGiNX based open source project

Piotr Sikora July 22, 2010 06:22PM

Re: DB Relay - NGiNX based open source project

Piotr Sikora July 22, 2010 06:28PM

Re: DB Relay - NGiNX based open source project

Brian Bruns July 22, 2010 06:30PM

Re: DB Relay - NGiNX based open source project

Piotr Sikora July 22, 2010 07:04PM

Re: DB Relay - NGiNX based open source project

agentzh July 31, 2010 02:42AM

Re: DB Relay - NGiNX based open source project

Brian Bruns July 31, 2010 09:20AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 222
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready