May
07
2007
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 [...]
Tags: benchmark, comparison, Database, Freeradius, Mysql, performance, Postgresql, radius
Apr
18
2007
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. [...]
Tags: cluster, Database, failover, hearbeat, high availability, mon, Mysql, redundancy, replication
Apr
01
2007
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 [...]
Tags: cluster, Database, failover, high availability, Mysql, redundancy, replication