Oracle^® Solaris Cluster Data Service for MySQL Guide

Debugging the HA for MySQL

HA for MySQL has a file named config that enables you to activate debugging for MySQL resources. This file is in the /opt/SUNWscmys/etc directory.

How to Activate Debugging for HA for MySQL

1. Determine whether you are in a global zone or in an HA Zone configuration.
2. Determine whether debugging for HA for MySQL is active.

   # grep daemon /etc/syslog.conf
   *.err;kern.debug;daemon.notice;mail.crit        /var/adm/messages
   *.alert;kern.err;daemon.err                     operator
   #

   If debugging is inactive, daemon.notice is set in the file /etc/syslog.conf of the appropriate zone.

3. If debugging is inactive, edit the /etc/syslog.conf file in the appropriate zone to change daemon.notice to daemon.debug.
4. Confirm that debugging for HA for MySQL is active.

   If debugging is active, daemon.debug is set in the file /etc/syslog.conf.

   # grep daemon /etc/syslog.conf
   *.err;kern.debug;daemon.debug;mail.crit        /var/adm/messages
   *.alert;kern.err;daemon.err                    operator
   #

5. Restart the syslogd daemon in the appropriate zone.

   # svcadm restart system-log

6. Edit the appropriate /opt/SUNWscmys/etc/config file to change the DEBUG= parameter.

   The value of component-name can be ndb_mgmd, ndbd, ndbd_shutdown.

   • To debug all resources, use DEBUG=ALL.

   • To debug specific resources, use DEBUG=resource name,resource name[, …].

   ---

   Note -  To deactivate debugging, repeat this procedure after you change daemon.debug to daemon.notice and the DEBUG variable to DEBUG=.

   ---

# cat /opt/SUNWscmys/etc/config
#
# Copyright 2012 OracleCorporation.  All rights reserved.
# Use is subject to license terms.
#
# Usage:
#       DEBUG=<RESOURCE_NAME> or ALL
#
DEBUG=ALL
#