Using IBM DB2 for i as a Storage Engine of MySQL

An IBM Redbooks publication


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




Profile

Publish Date
12 March 2009


Rating:
(based on 2 reviews)


Author(s)

ISBN-10
0738432407

ISBN-13
9780738432403

IBM Form Number
SG24-7705-00

Number of pages
220