I have 2 servers running 1 website. Server #1 is dedicated to Apache, serving the website files to the Internet. Server #2 is dedicated to MySQL, serving the database to the Server #1. Gigabit ethernet connects the 2 servers.
The problem I'm having is with Server #2, when traffic spikes, it causes MySQL to go away and I'm forced to restart MySQL to get thing back online again. When we reach too much traffic online, the pages just hang and everyone gets a database error screen.
I think the my.cnf file is not dialed in correctly and needs to be optimized.
Both servers are identical Dell PowerEdge servers, here are the specs:
- CPU - Dual Intel Xeon 2.40GHz
- Memory - 3GB of RAM
- Storage - 2x36GB 10K SCSI Hard Drives in RAID 1
- Linux - Debian GNU/Linux 4.0 (etch) kernel version 2.6.18-6-686 (SMP)
- Apache v2.2.3
- PHP 5.2.0-8+etch16
- MySQL 5.0.51a-24+lenny2+spu1-log