Hi Gerhard,
actually the correct name is save_memory() (in registrar module). I guess the latest stable has it.
regards, bogdan
Gerhard Zweimüller wrote:
Hi Bogdan,
your option 2, ignoring the error in MySQL works fine. Thanks a lot.
However I cannot find the mentioned save_mem() function. I tried to google it with: "save_mem site:iptel.org"
But without success. In which versions of ser should save_mem be present?
Regards, Gerhard
--- Bogdan-Andrei Iancu bogdan@voice-system.ro wrote:
Hi Gerhard,
there are two ways to solve it:
- 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.
- 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
______________________________________________________ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/