[Freeswitch-users] sharing Mysql database beetwen FS nodes

[Marcin M.]

Hi,
iam trying to use one mysql db beetwen Freeswitches but have some issues 
on each one fs:

For example  fs1dev:

[ERR] switch_odbc.c:514 ERR: [delete from sip_registrations where 
expires > 0 and expires <= 1409289251 and hostname='fs1dev']
[ERR] switch_odbc.c:514 ERR: [delete from registrations where expires > 
0 and expires <= 1409288616 and hostname='fs1dev']

fs3dev:

[ERR] switch_odbc.c:514 ERR: [delete from sip_registrations where 
expires > 0 and expires <= 1409284836 and hostname='fs3 dev']

Opensips on front as sip load balancer only (forwarding sip registration 
to fs machines)

on each node there is FreeSWITCH Version 1.2.12

Linux fs3dev 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64 GNU/Linux

  cat /etc/odbcinst.ini
[MySQL]
Description     = MySQL driver
Driver          = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup           = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount      = 1
FileUsage       = 1
Threading = 0

issue exist on Mysql 5.6  or Percona Galera  5.6.15-63.0 using same 
mysql version (InnoDB)

we tried to setup indexing, but this not help :

ALTER TABLE registrations ADD KEY r_host_expires (hostname,expires);
ALTER TABLE sip_registrations ADD KEY host_expires (hostname,expires);

there is no load at all on FS machines (up to 5 sip users registering).

Freeswitch configuration:

add to /usr/local/freeswitch/conf/autoload_configs/spidermonkey.conf.xml

<load module="mod_spidermonkey_odbc"/>

add to /usr/local/freeswitch/conf/autoload_configs/voicemail.conf.xml

|&lt;param name="odbc-dsn" value="odbc://freeswitch:root:password"/&gt;|

add to /usr/local/freeswitch/conf/autoload_configs/switch.conf.xml

<param name="core-db-dsn" value="freeswitch:fs:password" />
<param name="core-recovery-db-dsn" value="odbc://freeswitch:fs:password"/>
<param name="odbc-dsn" value="odbc://freeswitch:fs:password"/>
<param name="track-calls" value="true"/> <!--for recovery -->

<param name="switchname" value="fs1dev"/>
or
<param name="switchname" value="$${hostname}"/>

Sofia.conf.xml

Added odbc-dsn param setting under global_settings and under 
<settings></settings> in each sip profile:
sip_profiles/external.xml
sip_profiles/internal.xml
sip_profiles/internal-ipv6.xml

<param name="odbc-dsn" value="freeswitch:fs:password"/>

-----------

Main question is if FS 1.2.12 is designed for such configuration  ?
Maybe someone resolve that issue ?
Maybe it is fixed in some newest version of Freeswitch ?
Mysql tuning ?
Maybe someone  have enviroment that works without Deadlock issue ? which 
mysql and fs version  ?

thanks for any help
Marcin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140829/95945af6/attachment.html