hi can anyone give me a hint here of what's true and what's not?
i'm planning to use a multiple SIP proxy installation sharing location database using a MySQL cluster. i planned to use SER as proxy, but to me it seems like the SER caches location DB instead of reading from the MySQL database?
in a multiple proxy installation, every proxy may recieve an incomming REGISTER and store that registration to the shared mysql database. but if the other proxies caches the location database instead of reading from the cluster, they will never be aware of registrations not made by them self... so this makes the SER no good for my installation.
is this true or just bad rumours?
best regards, /Staffan
Staffan Kerker Saab Communications, Växjö m. staffan.kerker@saabgroup.com
Kerker Staffan wrote:
i'm planning to use a multiple SIP proxy installation sharing location database using a MySQL cluster. i planned to use SER as proxy, but to me it seems like the SER caches location DB instead of reading from the MySQL database?
Have a look at the usrloc-cl module in the experimental-branch of SER (CVS rel_0_9_0) or the db_mode=3 of the usrloc module in OpenSER (CVS HEAD).
Andy
On Thu April 13 2006 19:38, Andreas Granig andreas.granig@inode.info wrote:
Kerker Staffan wrote:
i'm planning to use a multiple SIP proxy installation sharing location database using a MySQL cluster. i planned to use SER as proxy, but to me it seems like the SER caches location DB instead of reading from the MySQL database?
Have a look at the usrloc-cl module in the experimental-branch of SER (CVS rel_0_9_0) or the db_mode=3 of the usrloc module in OpenSER (CVS HEAD).
Andy
Hi Kerker. I knew that db_mode could a value of 0, 1, or 2, but haven't heard of 3. What does db_mode=3 do that's different from 1 and 2?
Cheers, -- Nick e: nick.hoffman@altcall.com p: +61 7 5591 3588 f: +61 7 5591 6588
If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.
Hi!
Nick Hoffman wrote:
Have a look at the usrloc-cl module in the experimental-branch of SER (CVS rel_0_9_0) or the db_mode=3 of the usrloc module in OpenSER (CVS HEAD).
Hi Kerker. I knew that db_mode could a value of 0, 1, or 2, but haven't heard of 3. What does db_mode=3 do that's different from 1 and 2?
Do not confuse OpenSER and (Iptel) SER. db_mode 3 on Iptel SER is the READONLY DB mode (in CVS HEAD) which upon start reads data from a database and afterwards drops the connection. The somewhat same behaviour can be achieved using save_memory() on OpenSER.
The cacheless approach you are looking for has been implemented in the userloc-cl module as pointed out by Nick. Please take into account that synchronizing the MySQL cluster will result in performance penalties but on the other hand you should have everything in memory courtesy of MySQL ;)
What number of parallel registrations are you looking at? There are probably better ways of doing this than MySQL Cluster,
Hendrik
-
Andreas Granig -
Hendrik Scholz -
Kerker Staffan -
Nick Hoffman