[SR-Users] db_cluster.so module and kamctlrc DBHOST= field

[Olle E. Johansson]

> On 15 Feb 2016, at 22:32, Derek Bolichowski <derek at empire-team.com> wrote:
> 
> Hi there,
>  
> New user to Kamailio here. We currently have it up and running in a virtualized environment with 1 Kamailio sever, 1 Asterisk server and 1 MySQL server.
>  
> I’m currently writing install scripts to make deploying new nodes/servers easy and to keep settings the same across the board.  I’ve chosed to load the db_cluster.so module in kamailio.cfg, as we will have 2x MySQL servers in master-master replication which will contain the ‘kamailio’ and ‘asterisk’ tables.
>  
> I’ve just hit a stumbling block – in `kamctlrc`, there is a field called `DBHOST=`.  How can I reference my cluster here?
>  
> In kamailio.cfg, I simply define DBURL as “cluster//<clustername>”.  What is the syntax for ‘DBHOST=’ in ‘kamctlrc’?  Can I reference the cluster? Can I have 2 separate DBHOST= lines?
>  
> Looking for some guidance on this one.

kamctlrc controls Kamctl that is an outside script that one can decide to use to manage Kamailio. It has it’s own set of database connection methods and can’t use the cluster module in Kamailio.

There are two cases where kamctl and kamdbctl (the sister script) use database - to create the actual database and to search/update. With a master/master you decide if you create the tables on one side and let mysql replicate or if you create it on both sides before you initialize replication.

For other queries you can choose to simply refer to one of the servers in kamctlrc - it’s usually
not mission critical. If that server is down, your query will fail but the Kamailio service will run thanks to cluster logic in the db_cluster module.

If you want a similar functionality for kamctl you may want to install the mysql proxy that can do failover in a way similar to db_cluster. 

Cheers,
/O

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160217/21e18204/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2374 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160217/21e18204/attachment.bin>