Date: Wed, 12 May 2004 10:22:36 +0100 From: Peter Risdon <peter@circlesquared.com> To: Andy Holyer <andyh@hhbb.co.uk> 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. Message-ID: <40A1ECDC.3010508@circlesquared.com> In-Reply-To: <2CBADBFE-A3F2-11D8-86C0-000D93511A6A@hhbb.co.uk> References: <2CBADBFE-A3F2-11D8-86C0-000D93511A6A@hhbb.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40A1ECDC.3010508>