[OpenSIPS-Users] Help!! How to do failover of mysql connection

[Alex G]

clustering is really the way to go. Replication has too many downfalls.

On Sat, Nov 22, 2008 at 11:40 AM, Pablo Hernan Saro <pablosaro at gmail.com>wrote:

> Hi Krunal,
>
> As far as I know, the db_mysql module does not support fail-over. But you
> can do it out OpenSIPS.
> Search for MySQL proxy (it is what you need, but it stills alpha). Other
> possibility is to consider a MySQL cluster and a local replication in the
> same machine where OpenSIPS runs -with a secondary configuration file-, but
> you have to take care of switching to the local db.
> Hope it helps.
>
> Pablo
>
> On Sat, Nov 22, 2008 at 3:37 AM, Krunal Patel <krunal.lists at gmail.com>wrote:
>
>> Hi,
>>
>> Here is what I would like to implement:
>>
>>    - I am having 2 MySql servers. Lets say 192.168.1.5 & 192.168.1.6
>>    - Opensips is at 192.168.1.4.
>>    - I would like to use 192.168.1.6 mysql server for failover.
>>    - I mean to say if 192.168.1.5 goes down then opensips should start to
>>    use 192.168.1.6 mysql server.
>>
>> Please let me know is it possible?
>> If it is possible then how to do it?
>>
>> Thanks in advance!!
>>
>> --
>> Krunal Patel
>>
>>
>> _______________________________________________
>> 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
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081122/4b7d6f9b/attachment.htm