HP OSMS Blueprint: HP Manageability Value-Add Software for Open Source Middleware Stacks

MySQL High Availability Using HP Serviceguard
Overview
HP Serviceguard
HP Serviceguard is a specialized software for protecting mission-critical applications from a
wide variety of hardware and software failures. A high availability computer system allows
application services to continue even in the event of a hardware or software failure. High
availability systems protect users from software failures and from the failure of a system
processing unit (SPU), disk, or local area network (LAN) component. If one component fails, the
redundant component takes over. HP Serviceguard and other high availability subsystems
coordinate the transfer between components.
MySQL
MySQL is a robust, scalable, open source product that provides a high-performance, low-cost,
SQL-based enterprise relational database. For more information, see the MySQL website located
at:
http://www.mysql.com
MySQL Toolkit
The MySQL toolkit for HP Serviceguard consists of a set of shell scripts used by a package control
script to start, stop, and monitor the MySQL server package. The toolkit simplifies the effort of
making MySQL highly available by integrating MySQL with HP Serviceguard for Linux (SG/LX).
The architecture of MySQL High Availability uing HP Serviceguard is displayed in Figure 5.
Figure 5 Architecture of MySQL High Availability Using HP Serviceguard
In an SG/LX environment, MySQL must have the same configuration on all cluster nodes that
are configured to run the package. The node currently running the package is called the primary
node. All other nodes are called standby nodes. In the event of a failure on the primary node,
the package fails over to a standby node and the database continues to function. To ensure that
the database can fail over properly, all data must be stored on shared storage, and this storage
must be accessible to all nodes configured to run the package.
16