mysql fail over

[Peter Ellens]

Hi Alan

Would it be possible to implement time outs on the calls to the mysql
libraries? 

Thanks


-----Original Message-----
From: freeradius-users-bounces+peter=bccnz.com at lists.freeradius.org
[mailto:freeradius-users-bounces+peter=bccnz.com at lists.freeradius.org] On
Behalf Of Alan DeKok
Sent: Thursday, 11 December 2008 8:32 a.m.
To: FreeRadius users mailing list
Subject: Re: mysql fail over

Peter Ellens wrote:
> If I stop the first sql server service, freeradius starts to use the
> second sql server, as expected.
> 
> But if I stop the entire first server (ie poweroff) freeradius still
> continues to try and use sql1, hanging...

  FreeRADIUS is at the mercy of the MySQL client libraries.  It asks
them to connect, and if they never return... there's little that the
server can do.

> Any ideas how to get it working correctly?

  I presume that there's some magic MySQL client setting, saying "don't
screw up this badly", but I don't know what it is.

> We would really like to be able to use a read/write master and read only
> slave, but it looks to me that the sqlippool needs to be writeable to
> mark the IP address as used and avoid duplicate IP allocation.

  Yes.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html