[prev in list] [next in list] [prev in thread] [next in thread]
List: serusers
Subject: Re: [SR-Users] Is kamailio creating multiple connections to db?
From: Mino Haluz <mino.haluz () gmail ! com>
Date: 2013-01-28 12:16:28
Message-ID: CAFA7yDSduYMnmQuUDY1UMvOZocjxy0VVuwm=NFG2AQJ9UUuGRQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Yes, mysql cluster. It seems to be 2x slower than mysqld myisam, but who
cares, 3000q/s is ok for me.
On Mon, Jan 28, 2013 at 10:10 AM, Daniel-Constantin Mierla <
miconda@gmail.com> wrote:
> Adding references to two solutions:
> - shared IP with cross replication between mysql servers
> - mysql cluster
>
> Cheers,
> Daniel
>
>
> On 1/25/13 8:18 PM, Rumen Mihailov wrote:
>
> Hello Mino,
>
> Sorry for the offtopic, what HA database solution do you use ?
>
> Regards,
> Rumen
> On 25 Jan 2013 16:22, "Mino Haluz" <mino.haluz@gmail.com> wrote:
>
> > Hi,
> >
> > I made some DB test on our HA cluster, and I got that for 1 process I
> > have 1000 queries/sec and for 11 processes 3000 queries/sec. That's why I
> > would to ask if every kamailio process that is spawned has its own database
> > connection or queries are put in the queue and executed by some main
> > process ? I would like to know this, so that I could assess maximum call
> > count/sec that db can handle.
> >
> > Thank you,
> > Mino
> >
> > _______________________________________________
> > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> > sr-users@lists.sip-router.org
> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> >
> >
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing \
> listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - \
> http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, \
> Berlin
> - http://conference.kamailio.com -
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
[Attachment #5 (text/html)]
<div dir="ltr">Yes, mysql cluster. It seems to be 2x slower than mysqld myisam, but \
who cares, 3000q/s is ok for me.</div><div class="gmail_extra"><br><br><div \
class="gmail_quote">On Mon, Jan 28, 2013 at 10:10 AM, Daniel-Constantin Mierla <span \
dir="ltr"><<a href="mailto:miconda@gmail.com" \
target="_blank">miconda@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Adding references to two solutions:<br>
- shared IP with cross replication between mysql servers<br>
- mysql cluster<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 1/25/13 8:18 PM, Rumen Mihailov
wrote:<br>
</div>
<blockquote type="cite">
<p dir="ltr">Hello Mino,</p>
<p dir="ltr">Sorry for the offtopic, what HA database solution do
you use ?</p>
<p dir="ltr">Regards,<br>
Rumen</p>
<div class="gmail_quote">On 25 Jan 2013 16:22, "Mino Haluz" <<a \
href="mailto:mino.haluz@gmail.com" target="_blank">mino.haluz@gmail.com</a>> \
wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div dir="ltr">Hi,
<div><br>
</div>
<div>I made some DB test on our HA cluster, and I got that
for 1 process I have 1000 queries/sec and for 11 processes
3000 queries/sec. That's why I would to ask if every
kamailio process that is spawned has its own database
connection or queries are put in the queue and executed by
some main process ? I would like to know this, so that I
could assess maximum call count/sec that db can handle.</div>
<div><br>
</div>
<div>Thank you,</div>
<div>Mino</div>
</div>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" \
target="_blank">sr-users@lists.sip-router.org</a><br> <a \
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br> \
<br> </blockquote>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" \
target="_blank">sr-users@lists.sip-router.org</a> <a \
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a> \
</pre> </blockquote>
<br>
</div></div><div class="im"><pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" \
target="_blank">http://www.asipto.com</a> <a href="http://twitter.com/#!/miconda" \
target="_blank">http://twitter.com/#!/miconda</a> - <a \
href="http://www.linkedin.com/in/miconda" \
target="_blank">http://www.linkedin.com/in/miconda</a> Kamailio World Conference, \
April 16-17, 2013, Berlin
- <a href="http://conference.kamailio.com" \
target="_blank">http://conference.kamailio.com</a> -</pre> </div></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br> \
<br></blockquote></div><br></div>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic