Thanks William, I am considering the points you have mentioned already! yes you are right I have something to compare from which is good. Sir I forgot to mention that these servers are hosted servers from
www.oneprovider.com all of them with same specs and configurations. One thing I have planned during clustering is that i made sure every cluster contains same subnet of IPs so that all latency issues between the cluster communication gets killed. Secondly I have noticed that on DB server I see mysqld using 300% CPU and on dialers I see above 150-250% CPU usage by asterisk while memory is only being used by 0.6-1.0% on all. What can we do for that? I have used this ray solomon's link for the installation method for all servers (
http://ray-solomon.com/vicidial.html) my.cnf is also the same as below. Sir please let me know if I can post any other stats which may help me sort out this issue! Thank you.
[mysql.server]
user = mysql
#basedir = /var/lib
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir = /var/lib/mysql
#tmpdir = /home/mysql_tmp
socket = /var/lib/mysql/mysql.sock
user = mysql
old_passwords = 0
ft_min_word_len = 3
max_connections = 800
max_allowed_packet = 32M
skip-external-locking
log-error = /var/log/mysqld/mysqld.log
query-cache-type = 1
query-cache-size = 32M
long_query_time = 1
#slow_query_log = 1
#slow_query_log_file = /var/log/mysqld/slow-queries.log
tmp_table_size = 128M
table_cache = 1024
join_buffer_size = 1M
key_buffer = 512M
sort_buffer_size = 6M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
max_tmp_tables = 64
thread_cache_size = 8
thread_concurrency = 8
# If using replication, uncomment log-bin below
#log-bin = mysql-bin
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
#log-error = /var/log/mysqld/mysqld.log
#pid-file = /var/run/mysqld/mysqld.pid
Regards,
Samad.