Archive for the 'Mysql' Category

 

 

May 07 2007

Mysql or Postgres for Freeradius?

Published by under Freeradius,Mysql,Postgresql

We are not trying to build a full comparative of Mysql and Postgresql in this article. This subject has been discussed many times et everyone has his own opinion on this. Some directions may be given and only a few critirias will be analysed to be used with Freeradius. Criterias If we check what’s already […]

No responses yet

Apr 18 2007

Mysql Failover

Published by under Mysql

Important note: Heartbeat is now obsolete and has moved to a new stack available on Clusterlabs. For simple high availability project using a virtual IP, try out keepalived that does monitoring and failover with just a simple configuration file. When a Mysql server contains critical data, it’s always a good idea to rely on more […]

4 responses so far

Apr 01 2007

Mysql Replication

Published by under Mysql

Having a few databases running on Mysql with tables growing to several millions of rows, backups become pretty heavy. If the server fails, it can mean several hours lost, working on setting up a new server and reimporting the data from the backup. I’m not even talking about the potential financial loss due to the […]

4 responses so far

Oct 11 2006

Archive Accounting in Freeradius

Published by under Freeradius,Mysql

Logging Radius accounting into Mysql database can fill up a lot of space. Some performance issues will arise at some stage as well, especially if traffic reporting scripts are to be added to the overall system. That’s why we added a new table to log older accounting records. Motivations We can of course delete all […]

2 responses so far

« Prev