United States-English

HP Open Source Middleware Stacks Blueprint:: Database Server on HP Server Platforms with MySQL and Red Hat Enterprise Linux Version 5

»

Technical documentation


	Complete book in PDF


»	Feedback

» Table of Contents

HP Part Number: 5991–7431

Edition: 2.0

Published: August 2007

© Copyright 2007 Hewlett-Packard Development Company, L.P.

Acknowledgments

Table of Contents

Introduction

Executive Summary
Intended Audience
Scope and Purpose
HP Services

Typographic Conventions

HP Encourages Your Comments

HP Open Source Database Server Stack

Stack Components
Hardware Environment

Installing and Configuring the MySQL Database

Removing the Old Version
Installing MySQL
Configuring MySQL

Managing the MySQL Database

Starting and Stopping the MySQL Database
Creating and Deleting the MySQL Database
Administering User Accounts
Verifying Database Operation
Creating the Sample Database for MySQL

Configuring MySQL Server Replication

Configuring the Master Server and Slave Servers
Scaling MySQL Using Replication

MySQL High Availability Using HP Serviceguard

Introduction to HP Serviceguard and MySQL Toolkit
Testing Assumptions
Testing the MySQL Serviceguard Cluster

Monitoring the Database with the HP OpenView MySQL Gallery SPI

HP OpenView Operations Architecture
Software Prerequisites and Reference Guides
Using the SPIs

Backing Up Your Database

Installing and Configuring a Database Backup Tool
Backing Up Data
Restoring Data

Connecting External Systems to the MySQL Database

Connectors Included and Excluded from the Stack
JDBC Connector (Connector/J)
Installing the MySQL Connector/.NET Application
MySQL Connector/ODBC

Frequently Asked Questions

List of Figures

1 Hardware Environment
2 Check Basic Status Values
3 Checking Extended Status Values
4 Database Error Message
5 MySQL Replication Configuration
6 Replication Servers
7 HP OVOW Architecture
8 Importing a Client
9 Back Up the Slave Server
10 Restore Files
11 Employee Records List—Read-Write Test
12 Employee Records List—Read-Only Test
13 Microsoft IIS Manager
14 Create a Virtual Directory
15 .NET Framework Configuration Manager
16 Enable Record Editing

List of Tables

1 Commercial Open Source Packages
2 HP Value-Add Software
3 MySQL Components
4 Required OVOW Patches
5 Application Labels and Descriptions
6 MySQL Policies in the DBSPI MySQL Policy Group
7 Available MySQL Connectors

Printable version


Privacy statement	Using this site means you accept its terms	Feedback to webmaster

© 2007 Hewlett-Packard Development Company, L.P.