MySQL 5 vs. SMF (and maybe Mambo)
On NZRave.com, we run SMF 1.0.x and Mambo 4.5.1. Both are patched a bit to get around some nasty attacks.
I recently installed the new Braintrust database server. It’s got 2GB RAM, 2×1GHz P3 chips, and 2×320GB SATA disks in Linux software RAID1, and of course LVM on top. It’s not huge, but is plenty for our purposes for the moment.
I’m running Centos4 on this new box, and figured I’d use the `centosplus’ repository and get MySQL 5, PHP 5, and PostgreSQL 8. However, it turns out SMF doesn’t like MySQL 5 because of some precedence changes in the SQL parser. Balls.
Back to MySQL 4.x for me. That means I’ve got to drop back to PHP 4, and PostgreSQL 7, as the newer Centos packages all depend on one another somewhat.