Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
On Thu, Aug 31, 2017 at 09:28:46AM +0300, Juha Heinanen wrote: > > > Our solution was to switch to the mysql driver in kamailio and use the > > > galera loadbalancer > > > > In this solution, also loadbalancer must be made highly available, > > using, for example, corosync/pacemaker. > > Or run loadbalancer on each SIP proxy host. We use the latter, glb is a lightweight process and use some supervistor scripts to make sure it is running. But it is an extra external process to babysit, having a async aware cluster connector would be great. It is on my todo to take a look at when I get around to start modifying kamailio, should be relatively simple (in my mind) to call the async method from db_cluster instead of just returning a not supported. ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
Juha Heinanen writes: > > Our solution was to switch to the mysql driver in kamailio and use the > > galera loadbalancer > > (http://galeracluster.com/documentation-webpages/glb.html) to implement > > loadbalancing/failover to our mariadb galera master/master cluster. > > In this solution, also loadbalancer must be made highly available, > using, for example, corosync/pacemaker. Or run loadbalancer on each SIP proxy host. -- Juha ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
Daniel Tryba writes: > Our solution was to switch to the mysql driver in kamailio and use the > galera loadbalancer > (http://galeracluster.com/documentation-webpages/glb.html) to implement > loadbalancing/failover to our mariadb galera master/master cluster. In this solution, also loadbalancer must be made highly available, using, for example, corosync/pacemaker. -- Juha ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
Daniel Tryba writes: > Our solution was to switch to the mysql driver in kamailio and use the > galera loadbalancer > (http://galeracluster.com/documentation-webpages/glb.html) to implement > loadbalancing/failover to our mariadb galera master/master cluster. Thanks for the tip, -- Juha ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
On Tue, Aug 29, 2017 at 07:44:34PM +0300, Juha Heinanen wrote: > > Are you really using mysql directly? For example the cluster driver > > doesn't support async, regardless of the backend driver support. > > I re-checked, and, yes, I was using cluster driver. Had a feeling that would be case :) Our solution was to switch to the mysql driver in kamailio and use the galera loadbalancer (http://galeracluster.com/documentation-webpages/glb.html) to implement loadbalancing/failover to our mariadb galera master/master cluster. There are other solutions I imagine (mysql proxy). ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
Daniel Tryba writes: > Are you really using mysql directly? For example the cluster driver > doesn't support async, regardless of the backend driver support. I re-checked, and, yes, I was using cluster driver. -- Juha ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query
On Sat, Aug 26, 2017 at 05:52:40PM +0300, Juha Heinanen wrote: > sqlops README tells: > > 4.5. sql_query_async(connection, query) > > Make an async SQL query using 'connection', if implemented by db > driver module (e.g., db_mysql) > > my sqlops sqlcon parameter specifies mysql driver, but still i get to > syslog: > > Aug 24 08:02:05 rox1 /usr/bin/sip-proxy[13886]: ERROR: sqlops > [sql_api.c:427]: sql_do_query_async(): the db driver module doesn'tsupport > async query Are you really using mysql directly? For example the cluster driver doesn't support async, regardless of the backend driver support. ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users