From: Reindl Harald
Date: November 1 2012 3:41pm
Subject: Re: Mysql backup for large databases
List-Archive: http://lists.mysql.com/mysql/228565
Message-Id: <50929836.60601@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig63B916DBD0245466086A1EE0"

--------------enig63B916DBD0245466086A1EE0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable



Am 01.11.2012 16:36, schrieb Singer Wang:
> On Thu, Nov 1, 2012 at 11:34 AM, Rick James <rjames@stripped <mail=
to:rjames@stripped>> wrote:
>=20
>     Full backup:
>     * Xtrabackup (Backup: slight impact on source; more if you have MyI=
SAM (as mentioned))
>     * Slave (Backup: zero impact on Master -- once replication is set u=
p)
>     * LVM -- a minute of server down; see below
>=20
> Why do you need downtime?

because mysqld has many buffers in memory and there
is no atomic "flush buffers in daemon and freeze backend FS"

short ago there was a guy on this list which had to realize
this the hard way with a corrupt slave taken from a snapshot

that's why i would ALWAYS do master/slave what means ONE time
down (rsync; stop master; rsync; start master) for a small
timewindow and after that you can stop the slave, take a
100% consistent backup of it's whole datadir and start
the slave again which will do all transactions from the
binarylog happened in the meantime


--------------enig63B916DBD0245466086A1EE0
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlCSmDYACgkQhmBjz394AnkZ9gCfXdiT0DJKb3FPpRjyyMlWZmVg
czcAnRjs2l/IdupIzAoBywM/lCuQeEYj
=6zP4
-----END PGP SIGNATURE-----

--------------enig63B916DBD0245466086A1EE0--