MySQL DBA - Tips and Techniques Magazine

11 Nov 2014


For Solaris 10, Sun introduced the Service Management Facility. SMF is a framework that handles system boot-up, process management, and self-healing. It addresses the shortcomings of startup scripts and creates an infrastructure to manage daemons after the host has booted.

Note: Recent builds of Solaris Express, Nevada, and Solaris 10 updates are using SMF to start daemons such as mysql. The process below may vary. If your version of Solaris uses SMF, you will use the svcadm commands shown below to start/stop MySQL 5.

New SMF Method ( Notes for Sun Docs):

If you installed the MySQL 5 package on a version of Solaris that is using SMF instead of RC files, you will find that the package installed an SMF manifest for MySQL 5, and you can see the state of the service by using this command:

 # svcs -a | grep mysql

 disabled 13:36:01 svc:/network/cswmysql5:default


To make sure the MySQL 5 server starts (and also at reboot), issue this command:

# svcadm enable svc:/network/cswmysql5:default

You can verify using this command again:

# svcs -a | grep mysql

online 15:12:43 svc:/network/cswmysql5:default

You can stop the server with command # svcadm disable svc:/network/cswmysql5:default and it will remain stopped, even across a reboot, until you issue the svcadm enable command.




a. Check the Machine Name


root@mk-n-portal-1[mysql] uname –n




b. Check the Operating System


root@mk-n-portal-1[mysql] uname –a


SunOS mk-n-portal-1 5.10 Generic_138889-03 i86pc i386 i86pc


c. Check the mySQL process and service on the Machine


root@mk-n-portal-1[~] svcs -a| grep mysql


online         11:08:23 svc:/application/database/sun-mysql50:default



d. Disable / stop mySQL


root@mk-n-portal-1[~] svcadm disable svc:/application/database/sun-mysql50:default


root@mk-n-portal-1[~] svcs -a| grep mysql


disabled       13:09:34 svc:/application/database/sun-mysql50:default



root@mk-n-portal-1[~] ps -ef | grep mysql


    root 11850 11811   0 13:09:55 pts/1       0:00 grep mysql


e. Enable / start mySQL


root@mk-n-portal-1[~] svcadm enable svc:/application/database/sun-mysql50:default


root@mk-n-portal-1[~] ps -ef | grep mysql

   mysql 11932   929   0 13:10:55 ?           0:00 /bin/sh /opt/webstack/mysql/5.0/bin/mysqld_safe --user=mysql --datadir=/var/opt

  root 11958 11811   0 13:10:57 pts/1       0:00 grep mysql

 mysql 11955 11932   0 13:10:55 ?           0:00 /opt/webstack/mysql/5.0/bin/mysqld --basedir=/opt/webstack/mysql/5.0 --datadir=



No comments:

Post a Comment