MY.CNF Recommendations

[voipclear]

Hello,

What settings should I change in my.cnf if I plan to have a DB server that will handle 100 simultaneous agents dialing at a 4.0 ratio?

Thanks in advance.

[mflorell]

Please post the hardware specs for all servers in your cluster.

[voipclear]

Hi Matt,

Here are my specs. Thanks.

Asterisk/Vicidial Servers (0 Outbound Trunks Enabled):
Physical Server (x2 / 50 Agents Per Server)
- 2X Intel(R) Xeon(TM) CPU 2.66GHz CPU
- 4GB RAM
- 80 GB Basic SATA

Asterisk Only Servers (Outbound Trunks Enabled):
Physical Server (x4)
- 2X Intel(R) Xeon(TM) CPU 2.66GHz CPU
- 4GB RAM
- 80 GB Basic SATA

Web Servers:
Xenserver PVM (x5 / 20 Agents Per VM)
- 4X Shared Cores on 2X Six-Core AMD Opteron(tm) Processor 2427
- 2GB RAM Per VM
- 40 GB Per VM Sharing 4TB NAS Mounted Drive (8X 1TB RAID0+1)

MySQL Servers:
Xenserver VM (VM not on the same physical server as Web Servers)
- 8 Dedicated Cores on 2X Six-Core AMD Opteron(tm) Processor 2427
- 24GB Dedicated RAM
- 300GB Deciated HD Space on RAID1 Raptor 10K SATA Drives

Recording FTP Server w/ Apache Enabled for Recording Link:
Xenserver VM
- 2 Cores on 2X Six-Core AMD Opteron(tm) Processor 2427
- 2GB RAM
- Sharing 4TB NAS Mounted Drive (8X 1TB RAID0+1)

[mflorell]

Is there any way you can use a real server for your DB instead of a Virtual Machine?

That is really leaving you open to problems and unpredictable behavior.

For the my.cnf, start with the my-huge.cnf and double these variables:
key_buffer
max_allowed_packet
sort_buffer_size
read_buffer_size
read_rnd_buffer_size
myisam_sort_buffer_size

And add these lines:
max_connections = 600
wait_timeout = 28800
connect_timeout = 30
skip-innodb
skip-locking
skip-name-resolve