Thanks for not trashing MySQL here. I am a hardcore MS SQL Server DBA I run two SQL Server users groups, but I've got a soft spot in my heart for MySQL I use it all the time and always have the current alphas,betas, or gammas loaded somewhere in my enviornment. I run a web site that sees 10k page hits a day all of them have between 2 and 20 querries on them. The box I run it on is a POS celeron 800 with 256 meg of ram and a single IDE hard drive. It still has room to grow! I tested the same setup with MS SQL Server and damn near killed the box just on memory footprint alone. I didn't need stored procs or triggers, and I'm broker than a stepped on cookie so MySQL was a perfect fit for me. The right tool for the right job. I've housed as much as 350GB of data on a single MySQL install. I to pushes and pulls using DTS all the time to MySQL and it works fine the article did outline the good gatchas.

Great article!