DB Server Advice

[Nicolas Baradakis]

Abdul Lateef wrote:

> We have very big voip traffic, and currently we were
> using mysql DB with the following server
> configurations, But we are getting lot of problems
> some time the devise are failed, some time the
> database is slow
. Etc.

I don't think that buying expensive hardware is a long term solution.
You don't describe what the problems are, as there're different cases.

1. If you have problems with authorize queries, try using the MySQL
replication to share the load between several slaves. The auth queries
are read-only, therefore it doesn't matter to run these queries on the
slave databases.

http://dev.mysql.com/doc/refman/4.1/en/replication.html
http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/doc/load-balance.txt?rev=1.4

2. If you have problems with accouting queries, try using the module
rlm_sql_log and the script radsqlrelay. Acct queries are buffered and
inserted to the database according to the server capabilities.

http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/man/man5/rlm_sql_log.5?rev=1.2
http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/man/man8/radsqlrelay.8?rev=1.1

-- 
Nicolas Baradakis