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.

Published 12 March 2009

cover image

ISBN-10: 0738432407
ISBN-13: 9780738432403
IBM Form #: SG24-7705-00
(220 pages)

More options

Rate and comment

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

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 publication also read

Follow IBM Redbooks

Follow IBM Redbooks