[Users] Mysql reconnect problem

[Bogdan-Andrei Iancu]

Hi Dimo,

yes, there is a mechanism for hot reconnect to the mysql server. By 
default it is turned on.
see:
    http://www.openser.org/docs/modules/1.2.x/mysql.html#AEN68

regards,
bogdan

Dimo wrote:

> Hi All,
> I have a problem with openser reconnecting to my redundant mysql
> servers which hold the openser database.
>
> The database servers are in a cluster and if one fails the other takes
> over its IP address.
> In openser however the connection to the database is established only
> (i think) at the beginning.
> So when openser is running and one of my sql servers drops, and the
> other takes over the IP, i  get an error in openser saying that the
> mysql connection does not exist.
>
> Is there a way to make openser reconnect to mysql automatically
> without restarting it or some other way I can make this work?
>
> Best,
> Dimo
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>