Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for MySQL Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

## 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=`.

Example 1-5 Editing the Debug `Config` File

    # 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
    #

Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |