Hello, i am configuring db_cluster module in kamailio 3.3 I have configured in roun-robin read between two MySQL servers but the load is not distributed equally My configuration is that: modparam("db_cluster", "connection", "con1=>mysql://USER1:PASS1@1.1.1.1/DB") modparam("db_cluster", "connection", "con2=>mysql://USER2:PASS2@2.2.2.2/DB") modparam("db_cluster", "cluster", "cls1=>con1=9r9p;con2=9r9p") And the auth module with: modparam("auth_db", "db_url", "cluster://cls1")
But i have enabled the mysql logs and the major part of the querys are targeted to the second server Is there any cache by peer? What am i doing wrong?
Thanks in advance.
Hello,
how many queries you did for these observations?
The round robin is per process, not per instance (kamailio start many processes).
Cheers, Daniel
On 12/5/12 5:17 PM, Juan José Ivars wrote:
Hello, i am configuring db_cluster module in kamailio 3.3 I have configured in roun-robin read between two MySQL servers but the load is not distributed equally My configuration is that: modparam("db_cluster", "connection", "con1=>mysql://USER1:PASS1@1.1.1.1/DB http://USER1:PASS1@1.1.1.1/DB") modparam("db_cluster", "connection", "con2=>mysql://USER2:PASS2@2.2.2.2/DB http://USER2:PASS2@2.2.2.2/DB") modparam("db_cluster", "cluster", "cls1=>con1=9r9p;con2=9r9p") And the auth module with: modparam("auth_db", "db_url", "cluster://cls1")
But i have enabled the mysql logs and the major part of the querys are targeted to the second server Is there any cache by peer? What am i doing wrong?
Thanks in advance.
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
-
Daniel-Constantin Mierla -
Juan José Ivars