Skip to main content

Discovering MySQL on IBM i5/OS

An IBM Redbooks publication

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

thumbnail 

Published on 06 March 2008

  1. .PDF (4.7 MB)


Share this page:   

ISBN-10: 0738485691
ISBN-13: 9780738485690
IBM Form #: SG24-7398-00


Authors: Hernando Bedoya, Francisco Javier Dieguez, Bruno Digiovani, Erwin Earley and Shirley Pintos

    menu icon

    Abstract

    The MySQL Database Server is the leading open-source database offering and is the most popular database to use with PHP applications. MySQL AB boasts 11 million installations of the MySQL database, which is used in both large and small organizations.

    While the MySQL Database Server can be used independently of PHP, a large number of implementations of the MySQL Database Server on the IBM® System i™ platform are likely to be directly associated with PHP. PHP is a widely-used general-purpose scripting language that is especially suited for Web development. Typically, PHP is embedded inside of HTML and provides the business logic for enabling data access and manipulation from within HTML Web pages. Often the MySQL Database Server is the data repository that PHP applications will access and manipulate.

    The MySQL Database Server, especially when coupled with PHP, is well suited for the development and deployment of Web-based applications. In fact, the Web arena is seeing a steady shift away from customized development toward the deployment of Web applications by content owners who use open community applications to deploy their content with their own design and usage capabilities. Support for the MySQL Database Server on IBM i5/OS® facilitates the deployment of such applications on the System i platform.

    In this IBM Redbooks® publication, we explain how you can install, configure, tailor, and manage the MySQL Database Server on i5/OS. We also help to broaden your understanding of its architecture on i5/OS. In addition, we illustrate open community applications that can be installed and run on IBM i5/OS.

    Table of Contents

    Part 1. Introduction to the MySQL Database Server on i5/OS

    Chapter 1. Overview of the MySQL Database Server on i5/OS

    Chapter 2. Overview of the MySQL Database Server

    Part 2. Installing, configuring, and managing the MySQL Database Server on i5/OS

    Chapter 3. Installing and configuring V5.0 of MySQL Database Server on i5/OS

    Chapter 4. Administration: Tools and general tasks

    Chapter 5. Security, access control, and privileges

    Chapter 6. Backup and restore of the MySQL databases

    Chapter 7. Replication and clustering

    Part 3. Application support and usage

    Chapter 8. Open community application support on i5/OS

    Chapter 9. Querying a MySQL database

    Chapter 10. Porting non-MySQL databases

     

    Others who read this also read