9 Dec
2006
9 Dec
'06
1:57 a.m.
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