Print-friendly Version

Setting Up MySQL Cluster Software Using Solaris Zones Partitioning Technology

Hashamkha Pathan, August 2008

Introduction

This document describes how to set up MySQL Cluster software in a Solaris Zones environment, as if it were running on independent physical servers. This setup is useful for replicating an environment in-house without using multiple physical systems. The author shows that it is also possible to extend the setup to use Solaris Zones on different physical systems.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• Introduction
• Steps for Setting Up MySQL Cluster Software With Solaris Zones
  • 1. Create Solaris Zones
    • 1.1 Create the Zones Using the Command Line
    • 1.2 Create the Zones Using a Script
  • 2. Install MySQL Cluster Software
    • 2.1 Download and Install MySQL Cluster Software for the Solaris OS for x64 Platforms
    • 2.2 Set Up the Configuration for the MySQL Server (my.cnf)
    • 2.3 Verify Access to the MySQL Server
    • 2.4 Modify root User Environment (.profile)
  • 3. Configure and Test MySQL Cluster Software
    • 3.1 Configure the Management Node
    • 3.2 Configure the Data and SQL Nodes
    • 3.3 Start and Stop the Cluster
    • 3.4 Test the Cluster Operation
• Acknowledgments

For More Information

Here are additional resources:

• Documentation:
  • MySQL documentation site
  • System Administration Guide: Solaris Containers-Resource Management and Solaris Zones on docs.sun.com
• MySQL download sites:
  • http://www.sun.com/software/products/mysql/getit.jsp
  • http://dev.mysql.com/downloads/
• MySQL training courses
• Support:
  • Register your Sun gear
  • Services
  • SunSolve Online
• MySQL forums
• Other web sites and resources:
  • MySQL site on sun.com
  • mysql.com site
  • Features & Benefits - MySQL Cluster
  • MySQL and MySQL Cluster FAQs
  • Sun BluePrints article: Optimize MySQL Server on Sun x64 Servers and Storage
  • Resources on BigAdmin:
    • MySQL Resources for System Administrators
    • Creating a Script for Scheduled MySQL Backups (community submission)
    • Database Resource Collection
  • Resources on Sun Developer Network (SDN):
    • Using MySQL and Memcached on the GlassFish Application Server
    • Sun and MySQL: How It Stacks Up for Developers
  • Tech Days Events blog: MySQL and Java DB
• Events of interest to users of Sun products
  • Sun and MySQL Around the World--Meetup Mashup
  • Find a MySQL Meetup Group near you
  • Worldwide developer events
  • Current events

Unless otherwise licensed, code in all technical manuals herein (including articles, FAQs, samples) is provided under this License.