EON: mysql support

[Manojav Sridhar]

Is it possible to install the mysql database on eon?

[Andre Lue]

Hi Vajonam,

Adding a mysql database should not be too difficult. It's a simple compile on opensolaris from what I remember and there is also the option of installing from SVR4 packages. When compiling you should target the prefix=/usr/local.

Hope that helps

[Manojav Sridhar]

dre2kse,

i haven't had much luck with SVR4 package or a mysql compile. i tried downloading the binaries for opensolaris, but it was missing some c libs. any pointers in the right direction will help, thanks

vajonam

[Andre Lue]

use ldd to help determine where its looking for what, if it's actually missing or misplaced etc. It will show not found on the missing libs or post output and I will try to help.

eg ldd ls
libsec.so.1 => /lib/libsec.so.1
libnvpair.so.1 => /lib/libnvpair.so.1
libcmdutils.so.1 => /lib/libcmdutils.so.1
libcurses.so.1 => /lib/libcurses.so.1
libc.so.1 => /lib/libc.so.1
libavl.so.1 => /lib/libavl.so.1
libidmap.so.1 => /usr/lib/libidmap.so.1
libnsl.so.1 => /lib/libnsl.so.1
libuutil.so.1 => /lib/libuutil.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libm.so.2 => /lib/libm.so.2

[Manojav Sridhar]

dre2ske,

here is the requested output.

ldd ./mysqld
libmtmalloc.so.1 => /usr/lib/libmtmalloc.so.1
libthread.so.1 => /lib/libthread.so.1
libnsl.so.1 => /lib/libnsl.so.1
libm.so.2 => /lib/libm.so.2
librt.so.1 => /lib/librt.so.1
libsocket.so.1 => /lib/libsocket.so.1
libCstd.so.1 => (file not found)
libCrun.so.1 => (file not found)
libc.so.1 => /lib/libc.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libuutil.so.1 => /lib/libuutil.so.1
libgen.so.1 => /lib/libgen.so.1
libsmbios.so.1 => /usr/lib/libsmbios.so.1

[Andre Lue]

Hi Vajonam,

The missing libraries are from Sunstudio C compiler
libCstd.so.1 => (file not found)
libCrun.so.1 => (file not found)

to locate them
cd /opt/SUNWspro
du -ak | grep libC

then transfer a copy to /usr/local/lib/ on your EON storage. (binary kit is a must)

[Manojav Sridhar]

dre2kse,

I suppose you need me to find them in an full opensolaris dristro?

thanks

[Andre Lue]

It installs when you add the Sunstudio C compiler. Yes you can use the one from opensolaris.

[Manojav Sridhar]

dre2ske,

great news! i am able to now get it to run from the command line no problem! now the next this is how do i get the services added to service registry.

pardon my large number of questions, its partly due to my lack of opensolaris experience. I am a long time debian/linux user so I get that just fine.

oh also, setting autoexpand=true worked great! and my zpools expanded to larger LUN sizes! neato!

thanks again for your help so far!

[Manojav Sridhar]

dre2ske,

after some googling i found a SMF xml file that helped me set this up at

http://blogs.sun.com/ritu/entry/how_to_configure_mysql_to

then i added the following to my .backup

/usr/local/lib/libCstd.so.1
/usr/local/lib/libCrun.so.1
/var/svc/method/mysql
/var/svc/manifest/application/database/mysql.xml

and the following the .exec



ln -s /usr/local/lib/libCstd.so.1 /lib/libCstd.so.1
ln -s /usr/local/lib/libCrun.so.1 /lib/libCrun.so.1


seemed to do the trick.

but its still starting up too early, as my data dir on a zfs mount, what is the last service i need make it depend on? that will make sure all the zpools are imported. i need to start it up after at the end of the .exec.

for now i have the repo.db stored with the service disabled and then at the end i do a enable on the mysql service. is there a better way?

[Andre Lue]

Adding it to .backup is not needed if you have the binary kit installed.

As for proper starting, anywhere below the zpool import line in .exec should work.

I would also probably use the mysld startup method versus smf.

[Manojav Sridhar]

Post by Andre Lue
Adding it to .backup is not needed if you have the binary kit installed.

Can you explain why? as I would really like to understand the system a bit more.

Post by Andre Lue
I would also probably use the mysld startup method versus smf.

smf is nice and clean, any reasons behind your recommendation?

[Manojav Sridhar]

again,

did some searching on your blog and i forgot that bin kit is already symlinked to a persistent store/

thanks

[Andre Lue]

Post by Manojav Sridhar
smf is nice and clean, any reasons behind your recommendation?

True. Mostly because you would have to import the xml via svccfg and also run updimg.sh to preserve the changes versus symlinks and editing .exec