Date: Wed, 8 Apr 2009 11:17:58 +0200 From: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net> To: freebsd-questions@freebsd.org Cc: DAve <dave.list@pixelhammer.com> Subject: Re: Multiple instances of MySQL Message-ID: <200904081117.58218.mel.flynn%2Bfbsd.questions@mailing.thruhere.net> In-Reply-To: <49DB4D3E.3070301@pixelhammer.com> References: <49DAC610.6020404@pixelhammer.com> <5C4F1A401C316B7D2F625CCF@Macintosh-2.local> <49DB4D3E.3070301@pixelhammer.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200904081117.58218.mel.flynn%2Bfbsd.questions>