Hi all, 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. The current configuration is: OS: Red Hat Enterprise Linux ES 3 PROCESSOR: Dual 3.2 GHz Intel Xeon MEMORY : 2GB DDR RAM Hard Drive: 2 x 36.4GB SCA Ultra 160 SCSI Hard Drive (RAID 1) RAID CONTROLLER CHASSIS: 2U BACKUP AGENT: Legato Managed Backup Agent NETWRK: Aggregate Bandwidth 100GB per Month (included) Now we want to re-configure our servers, some one suggest me about SUN. But i need your suggestions, which will driver our database server without any problem. -------- Yours, Abdul Lateef Computer Programmer HATIF COM Mob: +974 - 5405022 Tel: +974 - 4883068 ICQ: 276994704 YM!: abdul_zu Fax: +974 - 4883063 Doha Qatar http://www.hatif.com __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/
Hi,
The current configuration is: OS: Red Hat Enterprise Linux ES 3 PROCESSOR: Dual 3.2 GHz Intel Xeon MEMORY : 2GB DDR RAM Hard Drive: 2 x 36.4GB SCA Ultra 160 SCSI Hard Drive (RAID 1) RAID CONTROLLER CHASSIS: 2U BACKUP AGENT: Legato Managed Backup Agent NETWRK: Aggregate Bandwidth 100GB per Month (included)
Now we want to re-configure our servers, some one suggest me about SUN. But i need your suggestions, which will driver our database server without any problem.
you dont say how many devices you have or what your concurrent requests are. your machine description above is a 'not bad beast' for doing MySQL on - I'm not sure what jumping platforms would acheive if the basics havent been looked at - ie your actual MySQL configuration and where the bottleneck really is. if you dont have a lovely /etc/my.cnf (or other) which has been tweaked according to your needs and your drive array hasnt been configured for database usage then your problem will move with you onto whatever server you use alan
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?re... 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?... http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/man/man8/radsqlrelay.8?... -- Nicolas Baradakis
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Abdul Lateef -
Nicolas Baradakis