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

[SamyGo]

Hi,

I don't think that the cluster module is recognized outside the
kamailio.cfg - In order to get your two Databases to work with DBHOST
string is maybe get a MySQL proxy used between the kamctl and the two
Databases. The MySQL proxy would decide if the first DB is down hence
connect to secondary DB.

Since Kamctl is a bash script if you add two lines your kamctl might just
take either first or the second one all the time.

I hope it answered a little bit of your query.

Regards,
Sammy



On Mon, Feb 15, 2016 at 4:27 PM, Hosted Services <hosted 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.
>
>
>
> Thanks,
>
> Derek B.
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160216/a7962027/attachment.html>