Ran into some issues with Mysql 5.0.x when updating some production
boxes. Tracked it back to Mysql itself so it's not a Gentoo thing, but
it's still annoying. And traffic in server has been a bit slow lately.
Previous to Mysql 5.0.40 or so Mysql would put the binary logs into
datadir, normally /var/lib/mysql, as defined by /etc/mysql/my.cnf. With
newer versions, Mysql uses pid-file, normally /var/run/mysqld/, for
log-bin files. Replication breaks when the location of files change
because Mysql assumes you just turned log-bin on.
The fix is to add a line specifiying the log-bin path.
For host www01 you'd use this line in your /etc/mysql/my.cnf and Mysql
will add the .000001 and .index files with that prefix to the dir.
log-bin = /var/lib/mysql/www01-bin
kashani
--
[EMAIL PROTECTED] mailing list
