Re: Kannel Multiple DB connection

Hi,

you can try to configure CNAME in DNS and put two IPs in round robin manner.
Then configure mysql connection with at least 2 connections and you should have
2 connections to different nodes.

Alex


Am 03.06.2014 um 11:23 schrieb Abdul Basit <[email protected]>:

> Hi, smii
> 
> Thank you for prompt reply. 
> 
> This is one way. right!
> 
> But my architecture is using two Mysql master nodes in parallel so i don't have one virtual IP or floating IP.
> Instead i have two DB IPs. 
> 
> Is there any way to open two DB connections on different IPs?
> 
> 
> --
> regards,
> 
> abdul basit | p: +92 32 1416 4196 | o: +92 30 0841 1445
> 
> 
> On Tue, Jun 3, 2014 at 4:02 PM, smii saber <[email protected]> wrote:
> Hi Abdul basit
> Normally in the mysql-connection group you have to configure the  host ip adresse of your mysql db, so:
> 1- you install you db cluser system 
> 2- configure the virtual ip on the  host ip adresse of your mysql in kannel configuration file
> 
> group = mysql-connection
> id = mydlr
> host = "virtual ip adress of your db nodes"
> username = foo
> password = bar
> database = dlr
> max-connections = 1
> 
> 
> 2014-06-03 9:37 GMT+01:00 Abdul Basit <[email protected]>:
> 
> Dear Team,
> 
> I am using kannel for SMPP connectivity and storing DLR in mysql DB.
> 
> Now working on a scalable solution using Mysql multi-master setup. 
> Currently Kannel connect to only 1 DB server for DLR storage.
> 
> Is there any way that i can configure kannel for multiple master DB servers (either in load balance mode or in failover manner)?
> 
> Looking forward for suggestions.
> 
> --
> regards,
> 
> abdul basit | p: +92 32 1416 4196 | o: +92 30 0841 1445
> 
>