[aklug] Re: Remote backup of MySQL database

From: Royce Williams <royce@tycho.org>
Date: Fri Feb 25 2011 - 07:39:03 AKST

Royce Williams said, on 02/25/2011 05:54 AM:
> Also, if any of your backup/transfer needs are in order to fuel being able to hit an exact copy of the data for development purposes, look into the Maatkit suite of tools from the Percona folks, especially "mk-table-sync", which is basically "diff" for MySQL tables. It spits out the list of SQL commands necessary to make one database look like the other.

Note that this is primarily good for spot-checking to make sure that
replicas are actually in sync, not for keeping them in sync. For some
cool replication, I've heard that Tungsten is pretty slick, but haven't
touched it yet.

Royce
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Fri Feb 25 07:39:12 2011

This archive was generated by hypermail 2.1.8 : Fri Feb 25 2011 - 07:39:13 AKST