HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

Table of Contents
Introduction............................................................................................................................................5
Executive Summary...........................................................................................................................5
Intended Audience............................................................................................................................5
Scope and Purpose............................................................................................................................5
HP Services........................................................................................................................................5
Typographic Conventions......................................................................................................................6
HP Encourages Your Comments............................................................................................................6
HP Open Source Database Server Stack.................................................................................................6
Stack Components.............................................................................................................................6
Hardware Environment....................................................................................................................7
Installing and Configuring the MySQL Database .................................................................................8
Removing the Old Version................................................................................................................8
Installing MySQL..............................................................................................................................9
Configuring MySQL..........................................................................................................................9
Managing the MySQL Database...........................................................................................................11
Starting and Stopping the MySQL Database...................................................................................11
Creating and Deleting the MySQL Database .................................................................................12
Administering User Accounts.........................................................................................................12
Verifying Database Operation.........................................................................................................14
Creating the Sample Database for MySQL......................................................................................15
Configuring MySQL Server Replication...............................................................................................16
Configuring the Master Server and Slave Servers...........................................................................17
Configuring the Master Server...................................................................................................17
Configuring the Slave Servers....................................................................................................18
Synchronizing Data....................................................................................................................19
Monitoring Replication Status ..................................................................................................20
Scaling MySQL Using Replication..................................................................................................21
MySQL High Availability Using HP Serviceguard..............................................................................23
Introduction to HP Serviceguard and MySQL Toolkit ...................................................................23
Testing Assumptions.......................................................................................................................23
Testing the MySQL Serviceguard Cluster ......................................................................................24
Testing the Cluster Connection .................................................................................................24
Testing the Cluster Stability ......................................................................................................25
Testing Cluster Failover .............................................................................................................26
Monitoring the Database with the HP OpenView MySQL Gallery SPI...............................................26
HP OpenView Operations Architecture..........................................................................................26
Software Prerequisites and Reference Guides.................................................................................27
Using the SPIs .................................................................................................................................27
Backing Up Your Database...................................................................................................................29
Installing and Configuring a Database Backup Tool.......................................................................29
Backing Up Data..............................................................................................................................30
Restoring Data.................................................................................................................................32
Connecting External Systems to the MySQL Database........................................................................32
Connectors Included and Excluded from the Stack........................................................................32
JDBC Connector (Connector/J)........................................................................................................33
Connecting with Tomcat............................................................................................................33
Installing the MySQL Connector/.NET Application.......................................................................37
Configuring the MySQL Connector/.NET Application.............................................................38
MySQL Connector/ODBC...............................................................................................................40
Importing and Exporting MySQL Data in Microsoft Excel.......................................................40
Frequently Asked Questions................................................................................................................42
Table of Contents 3