26 Aug
2017
26 Aug
'17
4:52 p.m.
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
27 Aug
27 Aug
1:49 a.m.
New subject: 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.
29 Aug
29 Aug
6:44 p.m.
New subject: 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
30 Aug
30 Aug
11:44 a.m.
New subject: 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:
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).
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.
12:03 p.m.
New subject: 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
31 Aug
31 Aug
8:24 a.m.
New subject: 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
8:28 a.m.
New subject: sql_do_query_async(): the db driver module doesn't support async query
Juha Heinanen writes:
Or run loadbalancer on each SIP proxy host.
-- Juha
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.
10:48 a.m.
New subject: 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:
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.
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.
2431
days inactive
2436
days old
7 comments
2 participants
participants (2)
-
Daniel Tryba -
Juha Heinanen