We've got [A]pache and [C]oldFusion installed so far. In part three, we're installing 64-bit [M]ySQL.
Since ColdFusion 6, it's been possible to run on 64-bit systems with 64-bit JVMs, just not officially. (If you're nice, I'll post how later.) 64-bit support was officially introduced for ColdFusion with version 8, but only for Solaris SPARC. As of the 8.0.1 release, Adobe gave us offical support for 64-bit on Windows, Linux, and Mac OS X.
I've done this countless times, yet I can never seem to remember how I did it the next time I need the code. This is so I don't have to hit up Google next time.
I've always appreciated the effort that Stephen Collins put into creating The ACME Guide, which takes you through the steps of setting up a local ColdFusion development environment. This is my walk through of setting up the latest and greatest ACME stack under 64-bit Ubuntu 8.04.
I know there are a lot of tutorials that use this technique. I also know there's a lot of inherited code (in any language) that contains this SQL. I also also know that - years ago - I too was a slave to SELECT MAX(id). But this is the 21st century and you need to stop using it.