JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for MySQL Guide     Oracle Solaris Cluster 3.3 3/13
search filter icon
search icon

Document Information

Preface

1.  Installing and Configuring HA for MySQL

Installing and Configuring HA for MySQL

HA for MySQL Overview

Planning the HA for MySQL Installation and Configuration

MySQL and Oracle Solaris Containers

Configuration Restrictions

Restriction for the HA for MySQL Data Service Configuration

Restrictions on the MySQL Configuration File

Restrictions for the MySQL Configurations

Restrictions on the MySQL Database Directory

Restriction for the MySQL smf Service Name in an HA Container

Examples for the File Systems Layout

Configuration Requirements

Components and Their Dependencies for HA for MySQL

Registration and Configuration File for HA for MySQL

Explanation of the my.cnf File

Installing and Configuring MySQL

Enabling MySQL to Run in a Global Zone Configuration

How to Enable MySQL for a Failover Resource

How to Enable MySQL to Run in a Scalable Configuration

How to Enable MySQL to Run in a Multiple-Master Configuration

How to Install and Configure MySQL in a Global Zone

Enabling MySQL to Run in a Zone Configuration

How to Enable MySQL for a Failover Resource

How to Enable MySQL to Run in a Scalable Configuration

How to Enable MySQL to Run in a Multiple-Master Configuration

How to Install and Configure MySQL in a Zone

How to Enable MySQL to run in an HA Container Configuration

How to Install and Configure MySQL in an HA Container

Verifying the Installation and Configuration of MySQL

How to Verify the Installation and Configuration of MySQL

Installing the HA for MySQL Packages

How to Install the HA for MySQL Packages

Registering and Configuring HA for MySQL

How to Register and Configure HA for MySQL as a Failover Service in a Global Zone Configuration

How to Register and Configure HA for MySQL as a Failover Service in a Zone Configuration

How to Register and Configure HA for MySQL as a Failover Service in an HA Container Configuration

How to Modify Parameters in the HA for MySQL Manifest

How to Remove an HA for MySQL Resource From an HA Container

How to Add an HA for MySQL Resource in a Scalable or Multiple-Master Configuration

Verifying the HA for MySQL Installation and Configuration

How to Verify the HA for MySQL Installation and Configuration

Understanding the HA for MySQL Fault Monitor

Resource Properties

Probing Algorithm and Functionality

Debugging the HA for MySQL

How to Activate Debugging for HA for MySQL

Upgrade to Oracle Solaris Cluster 3.3 1/13 Software When Using HA for MySQL

Upgrade to MySQL 4.x.x From 3.23.54 When Using HA for MySQL

Upgrade to MySQL Version 4.x.x From Version 3.23.54

A.  Deployment Example: Installing MySQL in the Global Zone

B.  Deployment Example: Installing MySQL in the Non-Global HA Container

C.  Deployment Example: Installing MySQL in a Non-Global Zone

D.  Deployment Example: Installing MySQL in a Scalable or Multiple-Master Configuration

Index

Upgrade to MySQL 4.x.x From 3.23.54 When Using HA for MySQL

Use the information in this section to understand how to upgrade to 4.0.12 when using HA for MySQL.


Note - The procedure will not describe how to upgrade to version 4.x.x. It includes only the steps to upgrade HA for MySQL to version 4.x.x. These steps assume that the new MySQL binaries are installed in the same place. If the new binaries are installed in a new directory, you must reregister the MySQL resource with a new MySQL Base directory.


Upgrade to MySQL Version 4.x.x From Version 3.23.54

Use this procedure to upgrade from MySQL version 3.23.54 to MySQL version 4.x.x.

  1. Shut down the HA for MySQL resource.
    # clresource disable MySQL-resource
  2. Become superuser or assume a role that provides solaris.cluster.admin RBAC authorization on one of the nodes in the cluster that will host MySQL.
  3. Install MySQL.

    MySQL should be installed onto a cluster file system. For a discussion of the advantages and disadvantages of installing the software on local versus cluster files systems, see Determining the Location of the Application Binaries in Oracle Solaris Cluster Data Services Planning and Administration Guide?Determining the Location of the Application Binaries? in Oracle Solaris Cluster Data Services Planning and Administration Guide.

    Download MySQL from http://www.mysql.com. If you intend to use local disks for the MySQL software, you will need to repeat this step on all nodes within Oracle Solaris Cluster.

  4. Start up the HA for MySQL resource.
    # clresource enable MySQL-resource
  5. Shut down the HA for MySQL fault monitor.
    # clresource unmonitor MySQL-resource
  6. Follow the instructions in the MySQL Documentation to upgrade the MySQL database.
  7. Start up the HA for MySQL fault monitor.
    # clresource monitor MySQL-resource