Disclaimer: 

Please note: Although OBSOLETED patches are available on SunSolve, Sun recommends using the most recent patches and the most recent revision of those patches. OBSOLETED patches do not include the latest bug fixes and/or product enhancements, and may require the installation of additional patches as a corrective measure.

Status: OBSOLETE

Patch Id: 126031-07

***********************************************************************
READ THE TERMS OF THE AGREEMENT ("AGREEMENT") IN THE LEGAL_LICENSE.TXT
FILE CAREFULLY BEFORE USING THIS SOFTWARE. BY USING THE SOFTWARE, YOU
AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE
TERMS, PROMPTLY DESTROY THE UNUSED SOFTWARE.
***********************************************************************
For further information on patching best practices and resources, please
see the Big Admin Patching Center, http://www.sun.com/bigadmin/patches/ 
***********************************************************************

Summary: Obsoleted by: 126031-08 Sun Cluster 3.2: Ha-MYSQL Patch for Solaris 9

Date:  Jun/24/2009

Installation Requirements:

NA

Solaris Release: 9

Sun OS Release: 5.9

Unbundled Product: Sun Cluster

Unbundled Release: 3.2

Xref: This patch available for Solaris 10 SPARC as patch 126032
                               Solaris 10 x86   as patch 126033

Topic: 

Sun Cluster 3.2: Ha-MYSQL Patch for Solaris 9

Relevant Architecture: sparc

BugId's fixed with this patch:

6514073 6516322 6535494 6555257 6608186 6611940 6637562 6671385 6702868 6736757 6737273 6771179 6772756 6772758 6776775 6793558 6804858 6805990 6806206

Changes incorporated in this version:

6804858 6805990 6806206

Patches accumulated and obsoleted by this patch:

127614-01 137678-02

Patches which conflict with this patch: 

Required Patches:

Obsoleted by:

Files Included in this Patch: 

/opt/SUNWscmys/bin/control_mysql
/opt/SUNWscmys/bin/functions
/opt/SUNWscmys/bin/probe_smf_mysql
/opt/SUNWscmys/etc/my.cnf_sample_master
/opt/SUNWscmys/etc/my.cnf_sample_slave
/opt/SUNWscmys/geocontrol/bin/functions
/opt/SUNWscmys/geocontrol/bin/mysql_geo_control
/opt/SUNWscmys/geocontrol/bin/mysql_geo_replication
/opt/SUNWscmys/geocontrol/etc/config
/opt/SUNWscmys/geocontrol/util/mysql_geo_config
/opt/SUNWscmys/geocontrol/util/mysql_geo_register
/opt/SUNWscmys/lib/functions_static
/opt/SUNWscmys/util/ha_mysql_config
/opt/SUNWscmys/util/ha_mysql_register
/opt/SUNWscmys/util/ha_mysql_smf_register
/opt/SUNWscmys/util/ha_mysql_smf_remove
/opt/SUNWscmys/util/mysql_config
/opt/SUNWscmys/util/mysql_register

Problem Description: 

6804858 mysql_register.ksh should not use pkginfo to determine cluster version
6805990 it should be possible to register more than one MySQL database in a protection group
6806206 MySQL geocontrol disables replication resource on validation
 
(from 126031-06)
 
6771179 mysql_config file lacks necessary information if geocontrol component should be configured
6772756 replication resource must always go online on the zone where the database resource is
6772758 ha_mysql_register script should not use old CLI
6776775 remove_configuration function reports an error if nothing to do
6793558 stopping replication resource results in an error
 
(from 126031-05)
 
        This revision accumulates feature point patch 137678-02.
 
(from 126031-04)
 
6608186 smf manifest should not depend on network/physical
6611940 MySQL replication slave should be detected if no master-host is declared in my.cnf
6671385 HA MySQL registration fails if the MySQL update contains non numeric characters
 
(from 126031-03)
 
6637562 need to add all changed binaries to U1 patches
 
(from 126031-02)
 
        This revision accumulates feature point patch 127614-01.
 
(from 126031-01)
 
6514073 shutdown of a MySQL server is terminated by pmf
6516322 agent never reports online if the MySQL port is not 3306
 
(from 137678-02)
 
6702868 MySQL agent probe is complaining about databasenames starting with # or double byte characters
6736757 the MySQL agent should deliver methods to work as a geographic editions script based plugin
6737273 the detection for the master.info file does not work for non standard locations
 
(from 137678-01)
 
6608186 smf manifest should not depend on network/physical
6611940 MySQL replication slave should be detected if no master-host is declared in my.cnf
6671385 HA MySQL registration fails if the MySQL update contains non numeric characters
 
(from 127614-01)
 
6535494 physical hostnames are still required for variable MYSQL_NIC_HOSTNAME in mysql_config file
6555257 mysql_register script completion text should be changed to reflect status of commands executed

Revision History: 

126031-05 126031-04 126031-06 126031-01 126031-03

Patch Installation Instructions: 

--------------------------------
There are three (3) possible procedures for installing patches on Sun
Cluster.  The proper method to use and any additional instructions,
for this patch are specified below in the "Special Install Instructions"
section.
 
Refer to the chapter entitled "Patching Sun Cluster Software and
Firmware" in the "Sun Cluster System Administration Guide" for a
description of the different install processes and instructions on how
to install Sun Cluster 3.2 patches.
 
Refer to the man pages for instructions on using 'patchadd' and
'patchrm' scripts provided with Solaris, to install and remove patches.

Special Install Instructions: 

-----------------------------
 
NOTE 1:  Before installing this patch, please be sure to install the latest
         patch utilities patches for your OS. This list of patches is defined
         at http://sunsolve.sun.com
 
         Please use the pull down list which appears after the text:
         "Latest Patch Update: To ensure the correct functioning of the
         patching utilities on your system, stay up to date on the
         following patches"
 
NOTE 2:  Patch revision -03 delivers features introduced during update 1.
         Patch revision -05 delivers features introduced during update 2.
 
NOTE 3. Before applying the patch, disable the fault monitor for all HA MySQL
        resources.
 
              clresource unmonitor <resource>
 
NOTE 4. Install this patch using procedure "Applying a Non-Rebooting Sun Cluster
        Patch" as described in "Patching Sun Cluster Software and Firmware"
        chapter of the "Sun Cluster Administration Guide".
 
NOTE 5. After applying the patch, enable the fault monitor for all HA MySQL
        resources.
 
              clresource monitor <resource>
 
NOTE 6. After installing this patch, there is a new variable  MYSQL_DATADIR
        in the mysql_config file.
 
        Every new instance of the MySQL agent needs the MYSQL_DATADIR variable
        in the mysql_config file.  Without filling in this variable the database
        preparation with mysql_register will fail.
 
        The MYSQL_DATADIR variable must point to the directory where MySQL's
        my.cnf file is stored.
 
NOTE 7. If you want to deploy MySQL in sparse zones, and if you install a
        downloaded package version, you should check if the package sets links
        under /usr/bin.  If yes use the tarball.

README -- Last modified date:  Thursday, September 10, 2009