Archive for the tag 'Database'

 

 

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 Records 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 archive older Freeradius accounting records. Motivations We can of course delete […]

2 responses so far

« Prev