Archive for the 'Mysql' Category

 

 

Apr 18 2007

Mysql Failover

Published by dave under Mysql

When a Mysql server contains critical data, it’s always a good idea to rely on more than one server. Implementing a cluster would be ideal in this situation and could offer a high availability setup. It gives the option to replace a node if it fails with no disruption of service or even data loss. [...]

4 responses so far

Apr 01 2007

Mysql Replication

Published by dave 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 dave 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 [...]

One response so far

« Prev