Oracle Blog

Blog for ritu

How to configure MySQL to run with Solaris Management Facility (SMF)

MySQL 5.0.45 is integrated with Open
Solaris build 79. It is available in Solaris Express Developer
Edition (SXDE) 01/08. MySQL 5.0.45 is integrated with Solaris Service
Management Facility (SMF).

This blog entry describes the steps that
were taken to integrate MySQL with SMF.

First a quick recap of what is SMF:

SMF is the core component of the predictive self-healing
technology available in Solaris 10, which provides automatic recovery
from software and hardware failures as well as adminstrative errors.
Some of the advantages of using SMF are as under:

Failed services are automatically
restarted in dependency order, whether they failed as the result of
administrator error, software bug, or were affected by an uncorrectable
hardware error.

More information is available about
misconfigured or misbehaving services, including an explanation of why
a service isn't running , as well as individual, persistent log files
for each service.

Problems during the boot process are
easier to debug, as boot verbosity can be controlled, service startup
messages are logged, and console access is provided more reliably
during startup failures.

Administrators can securely delegate
tasks to non-root users more easily, including the ability to
configure, start, stop, or restart services .

Large systems boot faster by starting services in parallel
according to their dependencies.

Below are the SMF service manifest and accompanying shell script
needed to integrate MySQL with Solaris SMF.

Perform the following steps to import the manifest into the
SMF repository.

Save the following XML code to a file called "mysql.xml" in
/var/svc/manifest/application/database. You need to create the
directory if it doesn't exist and have the appropriate privileges to
perform this action.