I learned a great truth about MySQL Cluster today, and I think MySQL in general actually:
Apparently, memory really does matter!
Heh. Imagine that. I mean, I knew it was true, but didn’t full realize it until I tried setting up a 8-node MySQL cluster on Pentium 4’s with 256MB of RAM. The performance was absolutely horrible. Seriously. So I switched some things around and the performance was way better with 2 P4’s with 512MB of RAM. We have a lab on campus with 2gb memory and Core Duos… with gigabit. That would be nice… 🙂