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
any idea why?
-- juha
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.
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
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).
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
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
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
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.
-
Daniel Tryba -
Juha Heinanen