Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-31 Thread Daniel Tryba
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

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-31 Thread Juha Heinanen
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

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-31 Thread Juha Heinanen
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

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-30 Thread Juha Heinanen
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

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-30 Thread Daniel Tryba
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 :)

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-29 Thread Juha Heinanen
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

Re: [SR-Users] sql_do_query_async(): the db driver module doesn't support async query

2017-08-26 Thread Daniel Tryba
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,