From owner-freebsd-isp@FreeBSD.ORG  Sat Jul 30 14:31:08 2005
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
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 A43E316A41F
	for <freebsd-isp@freebsd.org>; Sat, 30 Jul 2005 14:31:08 +0000 (GMT)
	(envelope-from sellis@d154-20-93-49.bchsia.telus.net)
Received: from priv-edtnes57.telusplanet.net (outbound01.telus.net
	[199.185.220.220])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 27CC843D45
	for <freebsd-isp@freebsd.org>; Sat, 30 Jul 2005 14:31:07 +0000 (GMT)
	(envelope-from sellis@d154-20-93-49.bchsia.telus.net)
Received: from d154-20-93-49.bchsia.telus.net ([154.20.93.49])
	by priv-edtnes57.telusplanet.net
	(InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id
	<20050730143102.BTOM14932.priv-edtnes57.telusplanet.net@d154-20-93-49.bchsia.telus.net>;
	Sat, 30 Jul 2005 08:31:02 -0600
Received: from d154-20-93-49.bchsia.telus.net (localhost [127.0.0.1])
	by d154-20-93-49.bchsia.telus.net (8.13.3/8.13.3) with ESMTP id
	j6UEUpOg062404; Sat, 30 Jul 2005 07:30:56 -0700 (PDT)
	(envelope-from sellis@d154-20-93-49.bchsia.telus.net)
Received: (from sellis@localhost)
	by d154-20-93-49.bchsia.telus.net (8.13.3/8.13.3/Submit) id
	j6UEUksf062403; Sat, 30 Jul 2005 07:30:46 -0700 (PDT)
	(envelope-from sellis)
Date: Sat, 30 Jul 2005 07:30:46 -0700
From: Sean Ellis <sellis@telus.net>
To: Sunil Sunder Raj <unixtools@hotmail.com>
Message-ID: <20050730143046.GG41622@telus.net>
References: <20050729222540.GD41622@telus.net>
	<BAY106-F33541D45B17A9A2FED351BAEC10@phx.gbl>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <BAY106-F33541D45B17A9A2FED351BAEC10@phx.gbl>
User-Agent: Mutt/1.5.9i
Cc: freebsd-isp@freebsd.org
Subject: Re: multiple mysql server
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: sellis@telus.net
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 30 Jul 2005 14:31:08 -0000

On Sat, Jul 30, 2005 at 07:29:12AM +0000, Sunil Sunder Raj wrote:

Hi Sunil,

thanks for your reply.

My need for a second mysql server is to allow me to implement a database
that will use the utf-8 character set, whilst maintaining some existing
databases that are using the default Latin1 character set. 

I've ammended what you suggest below based on what I've read in the
documentation. Does this look sound? Anybody? I realize that this is
more of a mysql question.  

> 1)  install mysql

Build with --with-extra-charsets to include utf-8

> 2)  copy the mysql data directory to say mysql1
> So you have /var/db/mysql and /var/db/mysql1
> 
> 3) Open the first mysql /var/db/mysql/my.cnf
> Change
> port            = <The port you want the first mysql to listen to>
> bind-address    = <The ip you want the first mysql to bind to>
> 
> 4) start the first mysql server
> 
> 5) Open the second mysql /var/db/mysql1/my.cnf
> Change
> port            = <The port you want the second mysql to listen to>
> bind-address    = <The ip you want the second mysql to bind to>
> 
> 6) Write the startup command for the second mysql server
> /usr/local/bin/mysqld_safe --bind-address=<The ip address you want to bind 
> the second mysql server to> --user=mysql --socket=/tmp/mysql1.sock 
> --datadir=/var/db/mysql1 --pid-file=/var/run/mysql1.pid

--default-character-set=utf8 --default-collation=utf8_general_ci &

Easy enough for me to try out on a test machine. If anyone has any
comments though I would be interested,

cheers,

Sean