HP OSMS Blueprint: Database Server on HP ProLiant Servers with MySQL and SLES10

ManualsBrandsHP ManualsSoftwareHP Linux Caliper Software Electronic LTU

Table of Contents

Introduction............................................................................................................................................5

Executive Summary...........................................................................................................................5

Intended Audience............................................................................................................................5

Scope and Purpose............................................................................................................................5

HP Services........................................................................................................................................5

HP Open Source Database Server Stack.................................................................................................6

Stack Components.............................................................................................................................6

Hardware Environment....................................................................................................................6

Installing and Configuring the MySQL Database .................................................................................7

Removing the Old Version................................................................................................................7

Installing MySQL..............................................................................................................................8

Configuring MySQL..........................................................................................................................8

Managing the MySQL Database...........................................................................................................10

Starting and Stopping the MySQL Database...................................................................................10

Creating and Deleting the MySQL Database .................................................................................11

Administering User Accounts.........................................................................................................11

Verifying Database Operation.........................................................................................................13

Creating the Sample Database for MySQL......................................................................................14

Configuring MySQL Server Replication...............................................................................................15

Configuring the Master Server and Slave Servers...........................................................................16

Configuring the Master Server...................................................................................................16

Configuring the Slave Servers....................................................................................................17

Synchronizing Data....................................................................................................................18

Monitoring Replication Status ..................................................................................................19

Scaling MySQL Using Replication..................................................................................................20

MySQL High Availability Using HP Serviceguard..............................................................................22

Introduction to HP Serviceguard and MySQL Toolkit ...................................................................22

Testing Assumptions.......................................................................................................................22

Testing the MySQL Serviceguard Cluster ......................................................................................23

Testing the Cluster Connection .................................................................................................23

Testing the Cluster Stability ......................................................................................................24

Testing Cluster Failover .............................................................................................................25

Monitoring the Database with the HP OpenView MySQL Gallery SPI...............................................25

HP OpenView Operations Architecture..........................................................................................25

Software Prerequisites and Reference Guides.................................................................................26

Using the SPIs .................................................................................................................................26

Backing Up Your Database...................................................................................................................28

Installing and Configuring a Database Backup Tool.......................................................................28

Backing Up Data..............................................................................................................................29

Restoring Data.................................................................................................................................31

Connecting External Systems to the MySQL Database........................................................................31

Connectors Included and Excluded from the Stack........................................................................31

JDBC Connector (Connector/J)........................................................................................................32

Connecting with Tomcat............................................................................................................32

Installing the MySQL Connector/.NET Application.......................................................................36

Configuring the MySQL Connector/.NET Application.............................................................37

MySQL Connector/ODBC...............................................................................................................39

Importing and Exporting MySQL Data in Microsoft Excel.......................................................39

Frequently Asked Questions................................................................................................................41

Table of Contents 3