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