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 >>>> >>> >>> >> >
