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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
