[asterisk-dev] Connection Pooling for Database Connection in AGI

[Elliot Otchet]

I forgot to list another component in use here (really the secret sauce) http://sqlrelay.sourceforge.net/

You'll notice that they even have a replacement driver for MySQL, though ymmv.

-Elliot

P.S. This is probably a good topic for the asterisk-users list.  Questions like this are probably best answered over there.

From: asterisk-dev-bounces at lists.digium.com [mailto:asterisk-dev-bounces at lists.digium.com] On Behalf Of Elliot Otchet
Sent: Wednesday, July 08, 2009 10:56 AM
To: Asterisk Developers Mailing List
Subject: Re: [asterisk-dev] Connection Pooling for Database Connection in AGI

An alternative to FASTAGI is to use the unixODBC package (http://www.unixodbc.org) and corresponding MySQL ODBC driver.  It is certainly a different approach, but I have had good personal success with it.  It does have a few drawbacks, so be sure to read up on the limitations (and creative ways to work around them).

Make sure you go with the 3.5X version of the MySQL ODBC connector.  The 2.x driver doesn't support connection pooling.
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-installation-binary-unix.html

Regards,

Elliot

From: asterisk-dev-bounces at lists.digium.com [mailto:asterisk-dev-bounces at lists.digium.com] On Behalf Of RAJNIKANT VANZA
Sent: Tuesday, July 07, 2009 7:10 AM
To: asterisk-dev at lists.digium.com
Subject: [asterisk-dev] Connection Pooling for Database Connection in AGI

hi friends,

i am a asterisk developer and c,c++ programmer.
i have written code for C AGI and in this written code for mysql database connection and select query.

i want to use connection pooling for database connection in C AGI.
is it possible to use connection pooling facitlity in C AGI ?

so, please, if u have any solution or suggestion help me about it.

--
Thanks and  Regards
Rajnikant Vanza
Call : +91-97374 56583

________________________________
This message is intended only for the use of the individual (s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to Calling Circles LLC and its affiliates. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.

________________________________
This message is intended only for the use of the individual (s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to Calling Circles LLC and its affiliates. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20090708/fb326db2/attachment-0001.htm