Re: Kannel Multiple DB connection

Hi saber,

I will try HA proxy for DB nodes connectivity.
Data sync on both nodes is master-master replication responsibility.
On Jun 3, 2014 4:57 PM, "smii saber" <[email protected]> wrote:

> Hi
> In this case try to use a HA proxy as a load balancer  between kannel and
> your db nodes, but in this case data is not the same in the tow nodes.
>
> Regards
> Saber
>
>
> 2014-06-03 10:23 GMT+01:00 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
>>>>
>>>
>>>
>>
>