[Off Topic] Mysql system optimization to work with Freeradius
Sorry for the off-topic, I have a problem with the authentication regarding the Radius with MySQL database. There are about 12k users who authenticate to 2 Radius servers and 1 MySQL. Accounting is done every 5 minutes and the IPs are in a PostgreSQL base. How much of the network is wireless during storms (I live in a tropical country) have to disconnect multiple users and when the station is restored have problems of "No DB Handles" which creates duplication of IP addresses in some cases. I have made some tests with various settings in MySQL, different file systems and when increasing the number of clients connecting to the system IO Wait begins to increase. When I make an appointment for an extract over a period of time a little bigger or my system performs the calculation of access franchise the situation worsens. See setups reports of Freeradius + MySQL in larger environments. Would advise evaluate PostgreSQL? Any suggestions to optimize the system? In the tests used a softraid (I know) and deactivated the Ext4 journaling on which gave me a good improvement. But do not feel comfortable working with the double filesystem + softraid, the more without journaling. I thank in advance the opinions on this subject. Under my system: OS: CentOS 7 Mem: 12G CPU: Xeon (R) CPU E5620 @ 2:40 BD: MariaDB 10.0.16 FS: EXT4 or XFS Raid: 10 (6 SATA disks 2TB 7200 RPM 64MB WD2003FYYS Cache SATA 3.0Gb / s) att Michell
On 5 Mar 2015, at 09:48, Michell Antunes <michell@certto.com.br> wrote:
Sorry for the off-topic,
I have a problem with the authentication regarding the Radius with MySQL database. There are about 12k users who authenticate to 2 Radius servers and 1 MySQL. Accounting is done every 5 minutes and the IPs are in a PostgreSQL base.
How much of the network is wireless during storms (I live in a tropical country) have to disconnect multiple users and when the station is restored have problems of "No DB Handles" which creates duplication of IP addresses in some cases.
Your max worker thread and max connection pool size are different, they should be the same. -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
On Mar 5, 2015, at 10:27 AM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
Your max worker thread and max connection pool size are different, they should be the same.
As a note: in v2.2.5 and later, the default configuration is to make them the same. I suggest the OP download 2.2.6 and see the configuration examples for the SQL module. It should also work on earlier versions. Alan DeKok.
Hi,
I have a problem with the authentication regarding the Radius with MySQL database. There are about 12k users who authenticate to 2 Radius servers and 1 MySQL. Accounting is done every 5 minutes and the IPs are in a PostgreSQL base.
a few things....you COULD keep with MySQL - in which case use of any of the many MySQL tuning scripts out there is a good start - 12000 users/records is TINY. even the basic my-small.cnf example database settings should suffice..ensure your using the memory of your server effectively, 12k entries is no memory usage really. use InnoDB engine rather than MyISAM etc. OR just move everything to PGSQL - and ensure its tweaked (by default its a LOT better but you still need to do some DBA work). also, is your accounting 'live' or buffered/proxies to accounting VS and done 'out of band'? if live, it could be the insertion/updates of accounting which is causing the radiusd processes to stall as the auths etc have to wait for threads to be dealt with and cleared out of the way. some use of more threads may also help here. benchmarking is very very useful - might show that its the disk subsystem causing part of the bottleneck. are you doign something like RAID5 or RAID10 in software? alan
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Arran Cudbard-Bell -
Michell Antunes