[OpenSER-Users] OpenSER with MySQL Cluster

[Christian Schlatter]

Juha Heinanen wrote:
> Christian Schlatter writes:
> 
>  > This mode ensures that all SIP registrations are directly written to the 
>  > 'location' mysql table, without being buffered in a memory cache. Since 
>  > mysql cluster uses in-memory databases, performance is pretty good even 
>  > with db_mode 3, at least if you run a cluster data node on the same host 
>  > as openser.
> 
> some of the presence stuff does not work with db_mode=3.  what is the
> disadvantage of using mode 1 or 2 in the proxy that receives register
> request from user and 0 in others?
> 
> -- juha

It doesn't matter if you have only one registrar. But if you want to do 
load-balancing/failover between multiple registrars, those registrars 
should access the shared mysql cluster tables instead of their local 
memory cache. If a phone registers with a proxy, the new registration 
state has to be known to all registrars immediately.

/Christian