[SR-Users] New MariaDB server "limiting" Kamailio CPS

[David Villasmil]

Did you check the max_connections in mysql?

https://mariadb.com/docs/reference/mdb/system-variables/max_user_connections/
and
https://mariadb.com/docs/reference/mdb/system-variables/max_connections/

Also, what are you doing with the db? how are your modules configured?


Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337


On Mon, May 31, 2021 at 7:20 PM Stephen Lokker <stephen.lokker at bitco.co.za>
wrote:

> [image: BitCo Business Broadband]
> <https://www.bitco.co.za/business-broadband-fibre-fno/>
> Good afternoon All,
>
> Im hoping for some advise or direction with the below. We are running a
> Kamailio SBC used for high call volumes and recently decided to upgrade the
> Database servers as the existing servers were struggling. Both the old and
> new databases are using MariaDB(version details all below), the problem we
> face is that since migrating to the new database there appears to a
> limitation to the amount of DB connections that can be processed or
> accepted. The SBC functions normally until the CPS starts to exceed around
> 100cps at which point the SBC stops responding to invites(in bursts which
> resembles flood prevention). We have checked both the Kamailio logs and the
> MySQL logs on the DB, both log files have no indication of errors that
> would cause the problem experienced(the logs attached are seen when the SBC
> is cut back to use the old DB, not sure they are related to the fault), the
> connections/processes in mysql do not drastically increase or get stuck
> either. The fault points to a db connection limit of some kind but all
> users have no limitations set. If anyone has experienced a similar problem
> or has any advise it would be greatly appreciated.
>
> Some info on the Kamialio and DB versions
>
> New DB
> root at voice-jhb-db01:~# mysql --version
> mysql  Ver 15.1 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64)
> using readline 5.2
>
> Old DB
> [root at isadb01 ~]# mysql --version
> mysql  Ver 15.1 Distrib 10.0.36-MariaDB, for Linux (x86_64) using readline
> 5.1
>
> Kamailio SBC
> [root at sbc01 ~]# kamailio -v
> version: kamailio 5.1.4 (x86_64/linux)
>
> Kind regards,
>
>
> * Stephen Lokker | BitCo Telecoms*
> *Voice Engineer*
> Website: www.bitco.co.za
> Email: stephen.lokker at bitco.co.za
> Telephone: 087 135 0000 | EXT: 2404
> Softphone Extension: 3468
>
> [image: BitCo Telecoms] <http://www.bitco.co.za>
>
> *Disclaimer*
>
> ‘This communication contains confidential information. All information
> contained in this email remains the intellectual property of BitCo and may
> not be used for any purpose or made available to any third party without
> the express written permission of an authorised BitCo representative.’
>
>
>
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
>   * sr-users at lists.kamailio.org
> Important: keep the mailing list in the recipients, do not reply only to
> the sender!
> Edit mailing list options or unsubscribe:
>   * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210531/ff9e1db8/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0.png
Type: image/png
Size: 27438 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210531/ff9e1db8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1.png
Type: image/png
Size: 168668 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210531/ff9e1db8/attachment-0003.png>