Installing MySQL on the i5
There is no doubt, now with Viper (which include native XML support), DB2 is most likely the most powerful database on the market. In many cases one would think if you’re using an i5, you might as well use DB2, not MySQL. Furthermore as of PHP 5 the MySQL extension is by default turned off. I guess by doing this PHP shows no bias towards any database, but like it or not, PHP’s rise to fame was done hand in hand with MySQL.
I’m in a position like this now; I’m playing around with some existing applications, looking to get them working on the i5. My biggest roadblock is thinking of some migration path from MySQL to DB2. Today I came across a tutorial on the Zend Developer Zone on installing MySQL on the i5. MySQL is not supported by IBM, so follow the linked-to tutorial at your own risk. From the tutorial:
MySQL is an open source database that has gained popularity in the web application world and is used in most of the leading/hot PHP (Hypertext Pre Processor) applications. Now that System i is a supported hardware platform for PHP with the availability of Zend Core for i5/OS, we have documented instructions for downloading, installing and running MySQL in the Portable Application Solution Environment (PASE) on the System i. MySQL is not an IBM i5/OS supported environment, use accordingly.
Have a second? Check out this great Canadian Health & Living Store based in Toronto