Installing MySQL on Solaris 10

"Configuring MySQL to Use With Service Management Facility (SMF)", by William Pool (Puddle), October 2005.  From http://www.sun.com/bigadmin/content/submitted/mysql_smf_tip.html

The Solaris 10 OS uses the Service Management Facility (SMF) to handle services.  Traditional means like /etc/rc?.d scripts still work, but as a legacy means.  To take advantage of the SMF in the Solaris 10 OS using MySQL, follow these steps.  (Note: Read the scripts and "change" the path of MySQL or MySQL's data-directory accordingly!)

If you haven't initialized the MySQL database, do that first:

/opt/sfw/bin/mysql_install_db

This will install the database into /var/mysql to override that use:

/opt/sfw/bin/mysql_install_db -ldata=/opt/sfw/var/mysql

Note: If you change the location, change the information below!

First create a mysql group:

/usr/sbin/groupadd mysql

Then create the mysql user:

/usr/sbin/useradd -s /bin/false -g mysql \
   -d /var/mysql -c "MySQL User" mysql

Create a service manifest file that contains the following:

cat > /var/svc/manifest/network/mysql.xml <<'EOF'

<?xml version='1.0'?>
 <!DOCTYPE service_bundle SYSTEM
 '/usr/share/lib/xml/dtd/service_bundle.dtd.1'>
<!--  William Pool (Puddle) 02/05
      Service manifest for MySQL
      E-mail: puddle@flipmotion.com
 -->

<service_bundle type='manifest' name='mysql:mysql'>

 <service
  name='network/mysql'
  type='service'
  version='1'>
 <create_default_instance enabled='false' />
  <single_instance />

  <dependency name='fs'

   grouping='require_all'

   restart_on='none'

   type='service'>

  <service_fmri value='svc:/system/filesystem/local' />

   </dependency>

  <dependency name='net'

   grouping='require_all'

   restart_on='none'

   type='service'>

  <service_fmri value='svc:/network/loopback' />

 </dependency>

 <exec_method

  type='method'

  name='start'

  exec='/lib/svc/method/svc-mysql start'

  timeout_seconds='-1'>

 <method_context>

  <method_credential user='mysql' group='mysql' />

  </method_context>

 </exec_method>

 <exec_method

  type='method'

  name='stop'

  exec=':kill'

  timeout_seconds='-1'>

 </exec_method>

 <exec_method

  type='method'

  name='restart'

  exec='/lib/svc/method/svc-mysql restart'

  timeout_seconds='-1'>

 </exec_method>

 </service>

</service_bundle>

EOF

 

Now create your "Service Method File" in /lib/svc/method called svc-mysql:

#!/usr/bin/sh

#

#        William Pool (Puddle) 01/05

#        SMF Method file for MySQL

#        E-mail: puddle@flipmotion.com

#

# This uses Sun's default MySQL packages

# SUNWmysqlu SUNWmysqlr

# Modify accordingly!

#

# NOTE: Make sure DB_DIR is owned BY the mysql

# user and group and chmod 700.

#

. /lib/svc/share/smf_include.sh

DB_DIR=/var/mysql

PIDFILE=${DB_DIR}/`/usr/bin/uname -n`.pid

 

case "$1" in

 start)

  /usr/sfw/sbin/mysqld_safe --user=mysql \
  --datadir=${DB_DIR} --pid-file=${PIDFILE} \
  > /dev/null &

 ;;

 stop)

  if [ -f ${PIDFILE} ]; then

   /usr/bin/pkill mysqld_safe >/dev/null 2>&1

   /usr/bin/kill `cat ${PIDFILE}` > /dev/null 2>&1 \
    && echo -n ' mysqld'

   fi

 ;;

 'restart')

  stop

  while pgrep mysqld > /dev/null

  do

   sleep 1

  done

  start

 ;;

 *)

  echo ""

  echo "Usage: `basename $0` \
    { start | stop | restart }"

  echo ""

  exit 64

 ;;

esac

Now fix the permissions for the two files created:

chown root:bin /lib/svc/method/svc-mysql
chmod 555 /lib/svc/method/svc-mysql
chown root:sys /var/svc/manifest/network/mysql.xml
chmod 444 /var/svc/manifest/network/mysql.xml

Fix permissions on the MySQL data directory:

chown -R mysql:mysql /var/mysql
chmod -R 700 /var/mysql

Import the service into the service repository:

svccfg import /var/svc/manifest/network/mysql.xml

Enable the service:

svcadm -v enable mysql