[OpenSIPS-Users] Help!! How to do failover of mysql connection
Pablo Hernan Saro
pablosaro at gmail.com
Tue Nov 25 14:03:59 CET 2008
That will not work. Try DNS SRV. Take a look at this link
Hope it helps.
On Tue, Nov 25, 2008 at 2:51 AM, Krunal Patel <krunal.lists at gmail.com>wrote:
> is it fine if I use DSN resolver?
> Let me explain in detail:
> I setup a DSN resolver & add A record for mysql servers.
> mysql A 192.168.1.5
> mysql A 192.168.1.6
> where 192.168.1.5 & 192.168.1.6 are mysql cluster nodes.
> So mysql.somedomain.com will point to both servers.
> It will do load balance & failover both.
> Please confirm that it will not create any issue.
> Krunal Patel
> On Tue, Nov 25, 2008 at 1:35 AM, Geoffrey Mina <geoffreymina at gmail.com>wrote:
>> This problem has been solved many times. The absolute most bomb-proof
>> MySQL failover solution involves a combination of DRBD and Linux HA
>> (Heart Beat). The replication model has too many issues IMO.
>> On Sun, Nov 23, 2008 at 9:10 AM, Uwe Kastens <kiste at kiste.org> wrote:
>> > Hi Krunal,
>> >> * I am having 2 MySql servers. Lets say 192.168.1.5
>> >> <http://192.168.1.5> & 192.168.1.6 <http://192.168.1.6>
>> >> * Opensips is at 192.168.1.4 <http://192.168.1.4>.
>> >> * I would like to use 192.168.1.6 <http://192.168.1.6> mysql
>> >> for failover.
>> >> * I mean to say if 192.168.1.5 <http://192.168.1.5> goes down then
>> >> opensips should start to use 192.168.1.6 <http://192.168.1.6>
>> >> mysql server.
>> > I am just on my way to implement the same. At the moment I am planing a
>> > kind of Mysql Master - Master together with one VIP for
>> > Mysql-opensips-communication. So for your example you will have to
>> > mysql-servers. opensips is connection to lets say to 192.168.1.4 which
>> > points on one of your mysql-servers. You will need active-active for
>> > mysql since opensips will write some information in the database as
>> > I am working with mysql-5 and heartbeat-2 in mode 1. Its nearly working.
>> > BR
>> > Kiste
>> > --
>> > kiste lat: 54.322684, lon: 10.13586
>> > _______________________________________________
>> > Users mailing list
>> > Users at lists.opensips.org
>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> Users mailing list
>> Users at lists.opensips.org
> Users mailing list
> Users at lists.opensips.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users