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
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
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 mailto: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 <mailto: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 list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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
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
Hello,
there is one connection to db server for each spawned process. The queries are executed by each process trough own connection.
Cheers, Daniel
On 1/25/13 3:22 PM, Mino Haluz 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
-
Daniel-Constantin Mierla -
Mino Haluz -
Rumen Mihailov