FreeBSD MYSQL configuration

FreeBSD does not automatically include a default my.cnf for MySQL. Instead, a set of sample configuration files can be found under /usr/local/share/mysql. These configuration files include my-small.cnf, my-medium.cnf, my-large.cnf, my-innodb-heavy-4G, and my-huge.cnf. The appropriate file can be copied and used as a …

more ...

Debian 4.0r4 NIC bonding

Install package ifenslave-2.6.

apt-get install ifenslave

make sure the real NICs kernel modules are loaded automatically

modprobe --list | grep -i bonding

edit /etc/network/interfaces to look like this:

auto bond0
iface bond0 inet static
address 192.168.1.59
netmask 255.255.255.0
gateway 192.168.1 …
more ...

what not to do in MySQL... and how to pick up the pieces

note to self... do NOT kill mysql processes from phpmyadmin's control panel and force mysql to quit. Bad things happen. In this case, mysql wouldnt start again. InnoDB's indexes, binary logs, etc. were all out of sync. The 20 page log explaining all the ways the DB couldn't start is …

more ...