[Serusers] Problem with MySQL Replication of 'subscriber' table

Andreas Granig andreas.granig at inode.info
Wed Sep 7 13:44:18 CEST 2005


Iqbal wrote:
> but then how do you replicate the other tables
> Klaus Darilion wrote:
>> Another option: Do not replicate the mysql data bases.

You can replicate the other tables in one direction, just leave out the 
usrloc tables like location and aliases and replicate them on SIP level.

Right before startup of one SER perform a mysqldump of the usrloc tables 
from the running peer and you should be fine (well, in fact you'd loose 
the registrations coming in at the peer between the start of the dump 
and the end of preloading the tables in usrloc module).

Andy




More information about the sr-users mailing list