Re: Freeradius Mysql Performance

2012-01-29 Thread Alan Buxey
Hi, >Sorry to pick into this with a short question. >Just wondering, do you see performance increase using postgres instead of >mysql? yes. I am a postgreSQL convert. though, that said - out of the box you get slightly better and safer performance - but you'll still have to configure

Re: Freeradius Mysql Performance

2012-01-29 Thread YvesDM
On Sun, Jan 29, 2012 at 11:36 AM, Alan DeKok wrote: > YvesDM wrote: > > Just wondering, do you see performance increase using postgres instead > > of mysql? > > Yes. > > MySQL can be higher performance than older versions of PostGreSQL, if > you don't do database writes. Newer versions of Post

Re: Freeradius Mysql Performance

2012-01-29 Thread Alan DeKok
YvesDM wrote: > Just wondering, do you see performance increase using postgres instead > of mysql? Yes. MySQL can be higher performance than older versions of PostGreSQL, if you don't do database writes. Newer versions of Postgres have similar performance to MySQL, with the benefit of allowi

Re: Freeradius Mysql Performance

2012-01-29 Thread YvesDM
On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey wrote: > What?? > You dont need that kind of hardware for job, sure. Throwing that kind of > horsepower might fix the speed but this is a DBA question. > > Look at your mysql configuration and see how it can be adjusted (my.cnf) > look at the engine in

Re: Freeradius Mysql Performance

2012-01-28 Thread Alan Buxey
It's do-able. Though I would be worried about failover and resiliancy. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius Mysql Performance

2012-01-28 Thread Marinko Tarlac
1 mil of users and one server... ??? Good luck... On 1/28/2012 10:57 AM, Morteza Milani wrote: Hi, Currently we use a server with the following features: * RAM: 4 GB * Processor: 1x E8400 3.0 GHz - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius Mysql Performance

2012-01-28 Thread Alan Buxey
What?? You dont need that kind of hardware for job, sure. Throwing that kind of horsepower might fix the speed but this is a DBA question. Look at your mysql configuration and see how it can be adjusted (my.cnf) look at the engine in use and see if you can use better..(eg innodb instead of my

Re: Freeradius Mysql Performance

2012-01-28 Thread Fajar A. Nugraha
On Sat, Jan 28, 2012 at 6:10 PM, Phil Mayers wrote: > On 01/28/2012 09:57 AM, Morteza Milani wrote: >> >> Hi, >> >> Our company is using freeradius as a VPN authentication& >> authorization system. In worse-case say we would have 1 Million users. >> Beside >> scaling our market, we are going to de

Re: Freeradius Mysql Performance

2012-01-28 Thread Giuseppe Marocchio
Dear, i've got same problem in the first time that i use freeradius, first of all, you need to tune your mysql ( my.cnf ) with right optimization, you can enable slow query logging in order to check if is mysql or freeradius problem. when your mysql works fine, you can tune freeradius, like incr

Re: Freeradius Mysql Performance

2012-01-28 Thread Phil Mayers
On 01/28/2012 09:57 AM, Morteza Milani wrote: Hi, Our company is using freeradius as a VPN authentication& authorization system. In worse-case say we would have 1 Million users. Beside scaling our market, we are going to develop an application to analyze users with data mining algorithms. Curre

Freeradius Mysql Performance

2012-01-28 Thread Morteza Milani
Hi, Our company is using freeradius as a VPN authentication & authorization system. In worse-case say we would have 1 Million users. Beside scaling our market, we are going to develop an application to analyze users with data mining algorithms. Currently we use a server with the following feature