[SR-Users] Multiple Kamailio Servers + Location Table

[Daniel W. Graham]

Confirmed that db_mode = 3 works as intended however db_mode = 2 results in all records disappearing.

-dan

From: sr-users [mailto:sr-users-bounces at lists.kamailio.org] On Behalf Of Daniel W. Graham
Sent: Wednesday, December 20, 2017 10:35 AM
To: miconda at gmail.com; Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table

Yes, to your first question, most records originally written by the active server disappear. Only way to restore all records to the location table is taking standby servers offline and restart Kamailio on active server. If a restart is not performed records wont reappear in table.
db_mode is 2
Database is replication is active passive.

Daniel W. Graham, CTO
CMSInter.net LLC
DIRECT (989) 400-4230

INTERNET | TELEPHONE | MANAGED IT

From: Daniel-Constantin Mierla [mailto:miconda at gmail.com]
Sent: Wednesday, December 20, 2017 3:48 AM
To: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org<mailto:sr-users at lists.kamailio.org>>; Daniel W. Graham <dan at cmsinter.net<mailto:dan at cmsinter.net>>
Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table


Hello,

On 20.12.17 06:28, Daniel W. Graham wrote:
When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.

Some entries remain, but it never populates to the normal amount unless only one server is using the database.
I couldn't figure out the proper picture of what happens based on the above ... some questions:

- only one server (the active) writes to database, with its own id (other servers have different ids), after a while some records written by the active server disappear?

 - is db_mode=3? If not, what value.

 - is there any replication at database layer?

Cheers,
Daniel



Anyone run into this before? Happened with 5.0 and is happening with 5.1.

-dan



_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users at lists.kamailio.org<mailto:sr-users at lists.kamailio.org>

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


--

Daniel-Constantin Mierla

www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>

Kamailio Advanced Training - www.asipto.com<http://www.asipto.com>

Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.com<http://www.kamailioworld.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171226/77a7c48e/attachment.html>