From owner-freebsd-isp@FreeBSD.ORG Fri Jul 29 20:15:14 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A8E6B16A41F for ; Fri, 29 Jul 2005 20:15:14 +0000 (GMT) (envelope-from nanard@tou.nu) Received: from smtp-ft4.fr.colt.net (smtp-ft4.fr.colt.net [213.41.78.203]) by mx1.FreeBSD.org (Postfix) with ESMTP id D807743D48 for ; Fri, 29 Jul 2005 20:15:13 +0000 (GMT) (envelope-from nanard@tou.nu) Received: from portable (lan-crysto.rev.coltfrance.com [62.23.202.89] (may be forged)) by smtp-ft4.fr.colt.net (8.13.4/8.13.4/Debian-3) with SMTP id j6TKFCjx001423; Fri, 29 Jul 2005 22:15:13 +0200 Message-ID: <023401c5947a$2f15b580$1401a8c0@portable> From: "nanard" To: , References: <20050729170146.GA41622@telus.net> Date: Fri, 29 Jul 2005 22:14:53 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Cc: Subject: Re: multiple mysql servers X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 29 Jul 2005 20:15:14 -0000 Hi, You just have to specify a different port , different socket, and different data directory to run it a second mysql server on the same box. : I didn't try this but you can: - Copy /var/db/mysql /var/db/mysql2 (and give same owner/perm than the other) - Create a my.cnf in /var/db/mysql2 and configure it. - Copy /usr/local/etc/rc.d/mysql-server.sh to /usr/local/etc/rc.d/mysql-server2.sh - In /usr/local/etc/rc.d/mysql-server2.sh, change in it "mysql_dbdir" variable to the new path and set mysql_enable to YES directly in it. Other solutions that i did, is to configure JAILS. Regards ----- Original Message ----- From: "Sean Ellis" To: Sent: Friday, July 29, 2005 7:01 PM Subject: multiple mysql servers > Hello, > > 4.11-STABLE FreeBSD 4.11-STABLE #2: Fri May 13 17:43:58 PDT 2005 > > can anyone recommend a good online resource for implementing a second > mysql daemon on freebsd? > > Or, perish the thought, any gotchas with this, > > thanks, > > Sean > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >