On Tuesday 07 April 2009 14:55:26 DAve wrote:

> > However, I would suggest that you provide, as you suggest, a separate
> > instance of mysql just for this client as well.  If they screw up the
> > instance they won't affect other customers.  To run a separate instance,
> > I would suggest using different names for the binaries, conf files and
> > datadir.  This can be easily done using symlinks; e.g. mysql and
> > mysql-special.  Then copy the startup script in /usr/local/etc/rc.d/,
> > rename it to mysql-special and edit it to change all references to the
> > newly-named instance.  Use a my-special.cnf file for the special
> > instance and reference it in /etc/rc.conf using mysql_args=.
>
> Thanks, looks like it would be doable. I do plan to use a separate
> my.cnf, separate logging, and even a seperate mysql DB. I was going to
> share the binaries but I may rethink that decision after your suggestion.

Any reason a jail can't be used? This would allow sharing the binary using 
null or union fs, little overhead, yet seperated from host install and no 
maintenance of port installed files, like rc.d/mysql-server.
-- 
Mel
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"

Reply via email to