From owner-freebsd-questions@FreeBSD.ORG Wed Apr 8 09:18:01 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 539A3106567C for ; Wed, 8 Apr 2009 09:18:01 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from mailhub.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id 1FF958FC1F for ; Wed, 8 Apr 2009 09:18:00 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from sarevok.dnr.servegame.org (gate.lan.rachie.is-a-geek.net [192.168.2.10]) by mailhub.rachie.is-a-geek.net (Postfix) with ESMTP id 6FB6E7E818; Wed, 8 Apr 2009 01:17:59 -0800 (AKDT) From: Mel Flynn To: freebsd-questions@freebsd.org Date: Wed, 8 Apr 2009 11:17:58 +0200 User-Agent: KMail/1.11.0 (FreeBSD/8.0-CURRENT; KDE/4.2.0; i386; ; ) References: <49DAC610.6020404@pixelhammer.com> <5C4F1A401C316B7D2F625CCF@Macintosh-2.local> <49DB4D3E.3070301@pixelhammer.com> In-Reply-To: <49DB4D3E.3070301@pixelhammer.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200904081117.58218.mel.flynn+fbsd.questions@mailing.thruhere.net> Cc: DAve Subject: Re: Multiple instances of MySQL X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Apr 2009 09:18:01 -0000 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