Deploying MySQL Database in Solaris Cluster Environments for Increased High Availability 
by Ritu Kamboj
November 2008
MySQL™ database, an open source database, delivers high performance and reliability while keeping costs low by eliminating licensing fees. The Solaris™ Cluster product is an integrated hardware and software environment that can be used to create highly-available data services. This article explains how to deploy the MySQL database in a Solaris Cluster environment. The article addresses the following topics:
- "Advantages of Deploying MySQL Database with Solaris Cluster" on page 1 discusses the benefits provided by a Solaris Cluster deployment of the MySQL database.
- "Overview of Solaris Cluster" on page 2 provides a high-level description of the hardware and software components of the Solaris Cluster.
- "Installation and Configuration" on page 8 explains the procedure for deploying the MySQL database on a Solaris Cluster.
This article assumes that readers have a basic understanding of Solaris Cluster and MySQL database installation and administration.
Contents
- Advantages of Deploying MySQL Database with Solaris Cluster
- Overview of Solaris Cluster
- Solaris Cluster: Hardware Components
- Solaris Cluster: Software Components
- Deployment Options Using Solaris Zones
- Installation and Configuration
- Install Solaris Cluster and MySQL Data Service Software
- Configure the Solaris Cluster Software
- Configure the File System
- Configure Solaris Cluster Resources for MySQL Data Service
- Install and Configure MySQL Database
- Conclusions
- About the Author
- Acknowledgements
- References
- Ordering Sun Documents
- Accessing Sun Documentation Online
About the Authors
Ritu Kamboj is a Staff Engineer in ISV Engineering's Open Source Team at Sun Microsystems. She has over 12 years of experience in software development with expertise on database design, performance and high availability. She has worked extensively on Sybase, Oracle and MySQL databases. Recently her primary focus has been making MySQL run best on the Solaris platform.
AcknowledgmentsThe author would like to recognize Gia-Khanh Nguyen and Detlet Ulherr from the Sun Cluster group for their contributions to this article.
Sign up or Log in to add a comment or watch this page.