Aug
01
2007
Some people using Radius for accounting don’t know there are counters limits. Values defined in the protocol are stored in 32 bit fields meaning you will never go any higher than 4294967296 bits, that is fairly more than 4GB. If a session stays up for days, there are good chances that the counter resets to […]
Tags: Accounting, Cisco, Database, Freeradius, linux, Mysql, radius
Jun
11
2007
This is related to Freeradius software but can be applied to any application that needs to encrypt Mysql traffic. Freeradius is compliant to Radius protocol characteristics, which give ability to accomplish various actions, such as authenticate users. Number of caveats have been found, not related to the software but to the protocol. Joshua Hill from […]
Tags: Database, Encryption, Freeradius, Mysql, Openssl, performance, radius, SSL
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 and 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. Criteria If we check what’s already […]
Tags: Database, Freeradius, Mysql, performance, Postgresql, radius
Apr
18
2007
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 […]
Tags: cluster, Database, Mysql
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, Mysql