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

[Pablo Hernan Saro]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081122/a37a9edd/attachment.htm