Jan Berg Sun, Databases, Norway

Let's Get It Up

Some tips around MySQL and SMF on OpenSolaris. You can enable the MySQL server by starting it through svcadm

% svcadm enable mysql

Although for current builds since the integration on build 79, you need to do this manual stuff first:

% su -
% cd /var
% mkdir mysql
% /usr/sbin/groupadd mysql
% /usr/sbin/useradd -g mysql -d /var/mysql mysql
% chown mysql:mysql mysql

So if your MySQL service is going into maintenance:

% svcs | grep mysql
maintenance    11:03:45 svc:/application/database/mysql:version_50

You could find out more what happened by doing:

% svcs -x
svc:/application/database/mysql:version_50 (MySQL RDBMS)
 State: maintenance since February 15, 2008  2:25:49 PM CET
Reason: Restarting too quickly.
   See: http://sun.com/msg/SMF-8000-L5
   See: MySQL 5.0.45(1)
   See: http://dev.mysql.com/docs
   See: /var/svc/log/application-database-mysql:version_50.log
Impact: This service is not running.

This will lead you to the above log-file, where you could get some useful information.

Another tip is that you can change where your datafiles should be, by doing:

% svcadm disable mysql:version_50
% svccfg                                               
svc:> select mysql:version_50
svc:/application/database/mysql:version_50> setprop mysql/data=/export/home/tmp/mysql/data
svc:/application/database/mysql:version_50> quit
% svcadm refresh mysql:version_50
% svcadm enable mysql:version_50

Remember that the directory specified need to be owned by mysql user and group!

Also you can read more about the MySQL integration and SMF at Ritu's blog

Posted at 04:11PM feb 15, 2008 by Jan Berg in Databases  |  Comments[0]