From owner-freebsd-isp@FreeBSD.ORG  Sat Jul 30 07:29:13 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 50E0716A41F
	for <freebsd-isp@freebsd.org>; Sat, 30 Jul 2005 07:29:13 +0000 (GMT)
	(envelope-from unixtools@hotmail.com)
Received: from hotmail.com (bay106-f33.bay106.hotmail.com [65.54.161.43])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1D52743D45
	for <freebsd-isp@freebsd.org>; Sat, 30 Jul 2005 07:29:13 +0000 (GMT)
	(envelope-from unixtools@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Sat, 30 Jul 2005 00:29:12 -0700
Message-ID: <BAY106-F33541D45B17A9A2FED351BAEC10@phx.gbl>
Received: from 65.54.161.204 by by106fd.bay106.hotmail.msn.com with HTTP;
	Sat, 30 Jul 2005 07:29:12 GMT
X-Originating-IP: [202.68.143.68]
X-Originating-Email: [unixtools@hotmail.com]
X-Sender: unixtools@hotmail.com
In-Reply-To: <20050729222540.GD41622@telus.net>
From: "Sunil Sunder Raj" <unixtools@hotmail.com>
To: sellis@telus.net, john@essenz.com
Date: Sat, 30 Jul 2005 07:29:12 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
X-OriginalArrivalTime: 30 Jul 2005 07:29:12.0848 (UTC)
	FILETIME=[62083900:01C594D8]
Cc: freebsd-isp@freebsd.org
Subject: Re: multiple mysql server
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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 07:29:13 -0000

Hi,
1)  install mysql
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 &

This works great for n number of mysql servers. Tested and working on one of 
my live servers.

-Sunil Sunder Raj

>From: Sean Ellis <sellis@telus.net>
>Reply-To: sellis@telus.net
>To: John Von Essen <john@essenz.com>
>CC: freebsd-isp@freebsd.org
>Subject: Re: multiple mysql server
>Date: Fri, 29 Jul 2005 15:25:40 -0700
>
>On Fri, Jul 29, 2005 at 01:08:07PM -0400, John Von Essen wrote:
>
>John,
>
> > >
> > > can anyone recommend  a good online resource for implementing a second
> >
> > http://dev.mysql.com/doc/mysql/en/multiple-servers.html
> >
>
>Thanks for the response. Quite a lot of detail there.
>
>To refresh my memory; I know how to supply make with options such as
>'WITH_CHARSET=utf8' when building the port, but how do I give a configure
>option like '--prefix=/usr/local/mysql-4.0.17'?
>
>--
>
>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"