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.