Issue with cuisql timing out on FR 3.12

[Alex Sharaz]

p.s. tried master/slave replication for accounting info and gave up,
couldn't get it  to work reliably

On 10 May 2016 at 12:17, Alex Sharaz <alex.sharaz at york.ac.uk> wrote:

> Well, we're planning a move to postgresql, the two FR servers use that for
> storing radacct and radpostauth info. Just running on mysql for the cui
> stuff while I still have the two FR 2.2.9 machines ( need to puppetise my
> ref 3.12 machine and use that to replace the 2.2.9 machines)
>
> Haven't checked yet if the same issue will arise with postgresql
> A
>
> On 10 May 2016 at 12:07, Alan DeKok <aland at deployingradius.com> wrote:
>
>> On May 10, 2016, at 5:59 AM, Alex Sharaz <alex.sharaz at york.ac.uk> wrote:
>> > So the above is happening because of the mysql backups and hence, every
>> > morning I get text messages saying both eduroam3 & eduroam4 are down ..
>> > which they're not.
>>
>>   Well, yes they mostly are... because the database is down.
>>
>> > Guess you're going to tell me to fix the mysql database access
>> > .... or is there something I can do to ignore cui stuff while the
>> database
>> > is being backed up?
>>
>>   You can ignore the CUI checks, but the problem will just show up
>> somewhere else.
>>
>>   If you're going to use MySQL, set up master/slave replication, and have
>> FreeRADIUS write to the master.  Then, back up the slave.
>>
>>   Or, switch to a real SQL database that doesn't break when people use
>> it.  Sorry... but MySQL is just not good enough.
>>
>>   Alan DeKok.
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>