Hi Gerhard,
there are two ways to solve it:
1) server which gets a replicated REGISTER updates only its cache and not also the DB (use save_mem()); doing so, the DB of the backup machine will be updated only via DB replication, so no overlapping.
2) configure mysql replication to ignore the error code for overlapping; See |"--slave-skip-errors" in| http://dev.mysql.com/doc/mysql/en/replication-options.html
regards, bogdan
Gerhard Zweimüller wrote:
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:
- 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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers