[Serusers] Fw: DB replication

[Jan Janak]

On 06-05 13:14, Andrea Bondavalli wrote:
>  Hi all,
>  
>  in order to achieve reliability I am currently trying to setup
> two SIP proxy responsible for a single DNS SRV domain.
> My User Agents do support a DNS fail-over
> mechanism and they are able to communicate with
> the secondary Proxy Server when the dialog with the Primary Proxy fails.
> At this time I am setting up two proxy servers (primary and secondary) both responsible
> for the same DNS SRV domain.
> Each Proxy do connect to its local mysql database (located on the same host 
> of the SER) and they are both configured to exchange REGISTERs  using the 
> t_replicate() function.
> Now I have to setup the mysql DB replication and I have some questions:
> 1) Is the described way of setting up a primary and a secondary Proxy server right ?

  Yes.

> 2) Which kind of DB replication should I setup ? 

  Whatever works best for you -- there are no special requirements.

> 3) Do I have to exclude the USRLOC table from the replication or not ?
>          (the USRLOC replication should be guaranteed by the REGISTERs exchange)

  Yes, you can exclude the table if you consider t_replicate reliable
  enough (i.e. the computers are on the same lan, for example).

    Jan.