From owner-freebsd-questions@FreeBSD.ORG  Wed May 12 02:18:57 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4018316A4CE
	for <freebsd-questions@freebsd.org>;
	Wed, 12 May 2004 02:18:57 -0700 (PDT)
Received: from dyer.circlesquared.com
	(host217-45-219-83.in-addr.btopenworld.com [217.45.219.83])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 306FA43D5F
	for <freebsd-questions@freebsd.org>;
	Wed, 12 May 2004 02:18:56 -0700 (PDT)
	(envelope-from peter@circlesquared.com)
Received: from circlesquared.com (localhost.petanna.net [127.0.0.1])
	i4C9MaSt077013;	Wed, 12 May 2004 10:22:36 +0100 (BST)
	(envelope-from peter@circlesquared.com)
Message-ID: <40A1ECDC.3010508@circlesquared.com>
Date: Wed, 12 May 2004 10:22:36 +0100
From: Peter Risdon <peter@circlesquared.com>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7b) Gecko/20040327
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Andy Holyer <andyh@hhbb.co.uk>
References: <2CBADBFE-A3F2-11D8-86C0-000D93511A6A@hhbb.co.uk>
In-Reply-To: <2CBADBFE-A3F2-11D8-86C0-000D93511A6A@hhbb.co.uk>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
cc: "<freebsd-questions@freebsd.org> <freebsd-questions@freebsd.org>"
	<freebsd-questions@freebsd.org>
Subject: Re: Mirroring Mysql databases - and secure tunneling, while I'm at
 it.
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 12 May 2004 09:18:57 -0000

Andy Holyer wrote:

> I've looked in the docs, and used google, and I need a quick steer as 
> to the best way to proceed.
>
> Our company is running two servers: one is a public web/mail/dns 
> server sitting in a rack at Telecity, the other one is sitting here 
> right next to me, and should never be seen outside of the office. Both 
> are running FreeBSD-CURRENT. Both carry MySQL databases: the public 
> one will carry cyrus mail, and authentication data for a radius 
> server, the private one will carry our customer account data.
>
> What I'd like to do, following my principle that buildings tend to 
> burn down one at a time, is to set the two databases to mirror each 
> other, so that we would be able to reconstitute either database if the 
> need were to arise. I'd like this to be as easy and automatic as 
> possible. Is there a standard vanilla way of doing this, or do I have 
> to get inventive?


Database replication is a standard feature of mysql. Look in the mysql 
docs for the word replication.

PWR.