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

Hi, let me briefly describe my problem: We run ser for quite a while already and are currently switching to a redundant system with 2 servers. Each of the servers runs Debian Sarge, an instance of MySQL 4.0.18 and ser_0.8.14. We implemented the replication of INVITE messages via SIP, so the other server always has all known SIP UAs in his RAM-cache. This works fine. Both SERs run in as follows: modparam("usrloc", "db_mode", 2) modparam("usrloc", "timer_interval", 20) The next task was to replicate the whole 'ser' db from MySQL-instance 1 as master to 2 as slave; and back again with 2 as master and 1 as slave. Now when the whole system is started up, we sometimes have problems and the replication stops: The reason is in the 'subscriber' table: 1. A new UA registers at the primary server 1. The data is stored in the local MySQL as well. Fine. 2. Then there is the SIP-Invite-Replicate to server 2, there again the data is stored in the local MySQL. Fine. 3. Now MySQL replication kicks in and tries to replicate the record from server 1 to 2. Unfortunately a record with same primary index exists already in server 2, but sometimes with a different timestamp. -> So replication fails and the "slave" process in server 2 stops. Do you know a way to overcome this? Can MySQL be configured to ignore errors (like this) in a replication? Thanks in advance! Gerhard __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers