mysql

On my last server to upgrade to Hardy, MySQL failed to start. Not sure why it only happened to this server, but trying to start MySQL resulted in:

/etc/init.d/mysql: ERROR: Using expire_logs_days without log_bin crashes the server. See README.Debian.gz

Sure enough, looking in /etc/mysql/my.cnf showed that log_bin was commented out, and expire_logs_days was enabled.

Uncommenting log_bin = /var/log/mysql/mysql-bin.log resolved the issue.

I've just finished building what is soon to become my new primary MySQL server. It's a dual CPU, dual-core AMD64 running at 2 GHz each. I've put 8 GB of RAM in it right now, but the board will support up to 64 GB. It's running three Raptor 10,000 RPM SATA drives in a Linux RAID 0 (striping) for performance. No, there's not a mirror or checksum because not only will it have daily off-machine backups but will also be replicating to a backup database server when it's up and running.

I've configured network bonding, so it effectively has a 2 Gbps connection to the network. Right now I'm doing some serious load testing on the Raptor's since I've had issues in the past with them on another chipset motherboard. So far so good!