<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
how many queries you did for these observations?<br>
<br>
The round robin is per process, not per instance (kamailio start
many processes).<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 12/5/12 5:17 PM, Juan José Ivars
wrote:<br>
</div>
<blockquote
cite="mid:CAO=uDhonJ6Hhdo-Ogjo0myxoxykmL=UAji0HH7aiijhpErRzVQ@mail.gmail.com"
type="cite">Hello, i am configuring db_cluster module in kamailio
3.3<br>
I have configured in roun-robin read between two MySQL servers but
the load is not distributed equally<br>
My configuration is that:<br>
modparam("db_cluster", "connection", "con1=>mysql://<a
moz-do-not-send="true" href="http://USER1:PASS1@1.1.1.1/DB">USER1:PASS1@1.1.1.1/DB</a>")<br>
modparam("db_cluster", "connection", "con2=>mysql://<a
moz-do-not-send="true" href="http://USER2:PASS2@2.2.2.2/DB">USER2:PASS2@2.2.2.2/DB</a>")<br>
modparam("db_cluster", "cluster", "cls1=>con1=9r9p;con2=9r9p")<br>
And the auth module with:<br>
modparam("auth_db", "db_url", "cluster://cls1")<br>
<br>
But i have enabled the mysql logs and the major part of the querys
are targeted to the second server<br>
Is there any cache by peer?<br>
What am i doing wrong?<br>
<br>
<br>
Thanks in advance.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>