[Devel] Patch: Multithreading support for mysql module

[Bogdan-Andrei Iancu]

Hi Henning,

Thanks for your contribution - the topic is a hot one and there a lot of 
interest for the patch. For the moment the CVS is frozen as the next 
release - 1.2.0 - is prepared.

But, please upload the patch on the tracker and after the release I will 
take a look on - just one question: to be honest I'm not so happy to mix 
multi-threads and multi-processing in OpenSER, so it was a special 
reason for going for threads?

Thanks and regards,
bogdan

Henning Westerholt wrote:
> Hello,
>
> the attached patch adds multithreading functionality based on the posix 
> threads library to the mysql module. We're using this module (in an older 
> version) with 0.9.5 to better support database failover scenarios. 
> As the porting to current cvs demanded heavy adaptions, this code is rather 
> untested now. This is probably not the right think to use in a production 
> environment for now.. Any suggestions and bug reports are welcome!
>
> This patch adds two new files for the threading functions to the mysql module 
> and should cleanly apply to cvs head. It starts a master and a worker thread. 
> If the worker hang due problems with the database, the master tries to 
> restart the worker after a configurable timeout value. 
> Compile with "EXTRA_DEBUG" to activate more locking checks and debugging 
> output. You need a multithreading capable mysql library to use this patch, 
> otherwise the module will not start.
>
>
> By the way, I would like to introduce myself:
>
> I work for the german internet service provider "1und1" as unix system 
> developer. We're using OpenSER as mentioned before as part of our VoIP system 
> for our customer since 0.9.X times. We have made many enchancements to this 
> version, some bugfixes and modules to provides new functionality as well.
>
> Now we would like to work more closely with the openser community, to help 
> with testing, bugfixing and feature enchancements. I already submit some 
> patches in the last weak, expect some more..
>
> I'm linux user since 2000, and occasional contributor to many open source 
> projects. I come from a C++/Java Background and have a good knowledge in 
> system-/ network administration topics. As my experience with openser 
> is limited at the moment, please bear with me if i ask sometimes obvious 
> questions.
>
> Thank you for the time for now - best regards,
>
> Henning Westerholt
>