MySQL - 2 Instances

Is it possible?

[cabbagehead]

Is it possible to run two discreet instances of MySQL on the same machine?

I have a great opportunity for hosting but they only support MySQL 4.0. My app relies heavily on subqueries however (a 4.1 feature) ... and meanwhile its apparently not possible to run a 4.0 dB on 4.1 for whatever reason (what ever happened to backwards compatability?!?!)

So, my only option at this point is to figure out if 4.0 and 4.1 can run simultaneously on the same box. If not, I guess I need to get a seperate box.

Thanks.

[zCat]

It's certainly possible, at least under Linux/*NIX, I've done it before, although it's a bit tricky to get the "second" instance configured.

I'm sure I read an article detailing how to do this on the MySQL site, though I can't find it right now. It might be on this page somewhere:
[dev.mysql.com...]