thank you! On Tue, Nov 3, 2020 at 8:15 PM Federico Edorna <fedo...@anura.com.ar> wrote:
> I didn't read that it was mysql, sorry. I think my suggestion is for > another thread :) > > Anyway, it seems that proxysql <https://proxysql.com/> can be a choice > for mysql... > > > On Tue, Nov 3, 2020 at 3:46 PM M S <medea...@gmail.com> wrote: > >> Thanks for the suggestion Federico. I'm using Myql, is there an >> equivalent? >> >> On Tue, Nov 3, 2020 at 3:42 PM Federico Edorna <fedo...@anura.com.ar> >> wrote: >> >>> If it helps, we are using pgbouncer <https://www.pgbouncer.org/> to >>> avoid opening a lot of connections to db. Pgbouncer acts as a db server for >>> opensips with full workers connections and opens just a few (on demand) to >>> real db server. It helps a lot when you have backup/standby opensips, not >>> increasing those db connections. >>> >>> >>> On Tue, Nov 3, 2020 at 9:13 AM Bogdan-Andrei Iancu <bog...@opensips.org> >>> wrote: >>> >>>> Maybe we should consider (as future extension) the possibility to >>>> bundle >>>> multiple UDP listeners on the same worker. In this case, we can have a >>>> large number of listeners with a relatively small number of workers/ >>>> processes. >>>> >>>> Regards, >>>> >>>> Bogdan-Andrei Iancu >>>> >>>> OpenSIPS Founder and Developer >>>> https://www.opensips-solutions.com >>>> OpenSIPS Bootcamp 2020 online >>>> https://opensips.org/training/OpenSIPS_eBootcamp_2020/ >>>> >>>> On 11/3/20 10:10 AM, Răzvan Crainea wrote: >>>> > Hello! >>>> > >>>> > No, there is no way to prevent OpenSIPS from opening connections for >>>> > each process. Did you try to start opensips with fewer workers, for >>>> > example just 1, or 3? Does it start properly? >>>> > >>>> > Best regards, >>>> > >>>> > Răzvan Crainea >>>> > OpenSIPS Core Developer >>>> > http://www.opensips-solutions.com >>>> > >>>> > On 11/2/20 1:55 PM, M S wrote: >>>> >> Thank you Bogdan. I actually use: socket=udp:*:5060 in config file. >>>> >> Is there a way to not open a process per interface, to not have 1200 >>>> >> or 600 workers? as I said in my previous email, I tried auto scaling >>>> >> and it didn't work. >>>> >> Also, I have increased MySQL max connections but it didn't fix >>>> >> the problem - I wonder if anybody has experience with this... >>>> >> >>>> >> Thanks! >>>> >> >>>> >> On Mon, Nov 2, 2020 at 9:24 AM Bogdan-Andrei Iancu >>>> >> <bog...@opensips.org <mailto:bog...@opensips.org>> wrote: >>>> >> >>>> >> Hi OpenSIPer, >>>> >> >>>> >> With 600 interfaces (btw , have actually listed the 600 sockets >>>> into >>>> >> the cfg or pointed the socket to the interface?) with 2 workers >>>> per >>>> >> socket -> 1200 workers / processes. That means 1200 connections >>>> to >>>> >> your DB server, which may be a bottle neck (by default, mysql >>>> >> accepts around 100 simultaneous connections). >>>> >> >>>> >> I suspect your mysql server cannot cope with the 1200 conn, >>>> >> preventing OpenSIPS to properly start. >>>> >> >>>> >> Regards, >>>> >> >>>> >> Bogdan-Andrei Iancu >>>> >> >>>> >> OpenSIPS Founder and Developer >>>> >> https://www.opensips-solutions.com >>>> >> OpenSIPS Bootcamp 2020 online >>>> >> https://opensips.org/training/OpenSIPS_eBootcamp_2020/ >>>> >> >>>> >> On 11/2/20 1:23 AM, M S wrote: >>>> >>> Hi all, >>>> >>> I have a machine with 600 subinterfaces. when I start opensips >>>> >>> with 2 udp workers per interface, it doesn't start and keeps >>>> >>> restarting. >>>> >>> First error message was about too many connections to Mysql >>>> which >>>> >>> I fixed by increasing max_connections, but now I am getting: >>>> >>> >>>> >>> ERROR:db_mysql:db_mysql_new_connection: initial connect failed >>>> >>> ERROR:core:db_do_init: could not add connection to the pool >>>> >>> ERROR:sql_cacher:child_init: Cannot connect to SQL DB from child >>>> >>> ERROR:core:init_mod_child: failed to initializing module >>>> >>> sql_cacher, rank 683 >>>> >>> ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken >>>> pipe >>>> >>> ERROR:core:udp_start_processes: failed to send -1 status code >>>> >>> ERROR:db_mysql:db_mysql_connect: driver error(2002): Can't >>>> connect >>>> >>> to local MySQL server through socket >>>> '/var/lib/mysql/mysql.sock' >>>> >>> (11) >>>> >>> >>>> >>> and: >>>> >>> >>>> >>> ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken >>>> pipe >>>> >>> ERROR:core:udp_start_processes: failed to send -1 status code >>>> >>> >>>> >>> Any ideas how I can fix this? >>>> >>> Also, can I just limit number of opensips forked processes, to >>>> run >>>> >>> just a certain number process instead of x numbers per >>>> interface? >>>> >>> I tried using auto_scaling but it did not help. in my >>>> >>> opensips.conf, I have: >>>> >>> socket=udp:*:5060 >>>> >>> and adding an autoscaling profile in front of it seems to limit >>>> >>> the processes per interface again, not all... >>>> >>> >>>> >>> Any help is appreciated. >>>> >>> >>>> >>> Thanks! >>>> >>> >>>> >>> _______________________________________________ >>>> >>> Users mailing list >>>> >>> Users@lists.opensips.org <mailto:Users@lists.opensips.org> >>>> >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >> >>>> >> >>>> >> _______________________________________________ >>>> >> Users mailing list >>>> >> Users@lists.opensips.org >>>> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >> >>>> > >>>> > _______________________________________________ >>>> > Users mailing list >>>> > Users@lists.opensips.org >>>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >>>> _______________________________________________ >>>> Users mailing list >>>> Users@lists.opensips.org >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users