With the Apache, MySQL™, and PHP (AMP) stack, IBM® i has the open source middleware to run thousands of PHP applications and scripts that have been written to the MySQL database. MySQL is a database that is used on millions of Web sites. To support the wide variety of usage, the developers of MySQL has developed an open storage engine architecture for data functionality and storage. Over a dozen storage engines are available for MySQL. IBM and Sun™ Microsystems have worked together to deliver a DB2® for i Storage Engine for MySQL. With this support, PHP applications written to MySQL database can have the data stored in the DB2 for i database. This approach provides management benefits for the IBM i customer because DB2 is integrated into IBM i and customers already know how to manage, back up, and protect DB2 data. In addition, the DB2 for i Storage Engine provides access to the MySQL data from IBM i environments such as RPG, CL, and DB2 Web Query. The DB2 for i Storage Engine offers the management and data access integration that can make IBM i the preferred platform for running open source applications for IBM i customers.

This IBM Redbooks® publication provides broad information to help you understand this storage engine. The book also helps you install, tailor, and configure DB2 for i Storage Engine for MySQL support.

Chapter 1. Overview

Chapter 2. Architecture and functional support

Chapter 3. Installing and configuring MySQL V5.1 Server on IBM i

Chapter 4. Implementation

Chapter 5. Configuration options and variables

Chapter 6. Transaction management and locking considerations

Chapter 7. Backup and restore considerations of the MySQL databases

Chapter 8. Security

Chapter 9. Problem determination and diagnosis

Chapter 10. Performance considerations and settings

Appendix A. Tool to lookup DB2 SQL and system names

Appendix B. How to start and stop MySQL server in IBM i