On the eve of 2010.. and your boss wants to stick to these MacOS X 10.5 machines, too stubborn or chicken to upgrade. Some developers still have their old PowerBook laptops and they need MySQL flying on PowerPC machines. To top it all, one guy said he wanted to have 32 and 64-bit in one bite. *Sigh* .. But there is an easy way out! A universal binary!

This post shows you a way to create MySQL universal binaries using MacOS X 10.6 so you can run them on MacOS X 10.5/10.6 whether it is PowerPC or Intel, or 32bit or 64bit.

However, if you need …

A week ago we found a workaround for a bug in MySQL Cluster making it impossible to run a management node on MacOS X. Until the bug is fixed, you should use the --nodaemon option for the ndb_mgmd executable. Both MySQL Cluster v6.3 and v7.0 are affected.

Currently, I'm starting the management node like this:

 (
  cd /opt/mysql/mysql ; 
  ./libexec/ndb_mgmd -f /opt/mysql/config.ini \
    --nodaemon 2>/dev/null 1>&2 </dev/null &
 )

Obviously, you'll want to change the paths.

Eventually, the bug will get fixed, but until then you got no excuse to not try MySQL Cluster on Mac!

What you do when you're fed up with a script? Right, you write your own.

You'll have to excuse me for the long shell script you'll find here below, but I'm not going to bother putting it on some download website.

It's a shell script which starts and stops the MySQL server. Indeed, a replacement for the init.d script found in the MySQL distributions. I'm using it personally on my Macs and it's not supported in any way.

But why? Well, I'm playing with MySQL Workbench, Server Administration. The MySQL init.d script didn't work right away (oh, various reasons for that), so I used mine. So I figured it might be useful for others and it's not complicated or shocking-new-stuff.

If you want to use it, you'll have to edit the 2 variables at the top. It's only …