[Users] Mysql reconnect problem

[Dimo]

Hi,
It works great, thanks!

Now that there is hot reconnect is there a possiblity to make ser
start without a database running? I am thinking about a scenario where
there is a network loss and my redundant opensers are restarting and
the database is restarting too but with some lag. In this scenario at
the moment of openser starting, the db is unavailable but it comes up
in 1-2 seconds after that. I guess hot reconnect will make things work
so there will not be the need to have the database online at the
moment of starting openser.
At present i cannot make ser start if there is a module requiring a db
and the db server is down.

Best,
Dimo



On 12/12/06, Bogdan-Andrei Iancu <bogdan at voice-system.ro> wrote:
> 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
> >
>
>