Using IBM DB2 for i as a Storage Engine of MySQL

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on March 12, 2009

  1. .PDF (3.5 MB)


Share this page:   

ISBN-10: 0738432407
ISBN-13: 9780738432403
IBM Form #: SG24-7705-00


Authors: Hernando Bedoya, Brad Bentley, Xie Dan Dan, Sadamitsu Hayakawa, Shirley Pintos, Guo Qi, Morten Buur Rasmussen, Satid Singkorapoom and Wang Yun

    menu icon

    Abstract

    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.

    Table of Contents

    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

     

    Others who read this also read