On Wed, Oct 25, 2017 at 01:31:30PM +0300, Uri Shacked wrote:
I started using db_cluster module. DB are master-slave replication both ways.
#!define DBURL "cluster://kamailio"
when i stop the primary mysql server, all subscribers fails to register again. seems like the usrloc module does not work with the cluster.
It has been a while since I used db_cluster with mysql master/slave. But it was on 4.2 and it worked with usr_loc. You have to dig a bit further to see what is happening with you queries.
Nowadays we use a mysql master-master setup (galera cluster with 1 connection from kamailio to a local galera load balancer)