From: Reindl Harald
Date: December 23 2011 10:03pm
Subject: Re: FULL mysqldump
List-Archive: http://lists.mysql.com/mysql/226505
Message-Id: <4EF4FAA7.3070004@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigDA0B754CD97CC8731DFB3987"

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



Am 23.12.2011 22:42, schrieb Wm Mussatto:
>> so you have a REAL consistent backup with minimal downtime you can res=
tore
>> on any machine and pull dumps of whatever you really need instead of
>> breaindead hughe dumps with long locking time while they are done or
>> withut locking inconsistent state
>>
>> the first rsync runs while the server is online and the second one
>> after mysqld is stopped takes a few moemnts because only changed data
>> in the meantime have to be synced again
>>
>> this way you can backup many GB of mysql-data with minimal downtime
>> and 100% consistence
>>
> This is true if the problem is many relatively small tables.  Not sure =
how
> well it would work if the problem was one or more very large tables.

does not matter if you look how rsync works

i am using rsync ober the WAN each day for backups or some TB real data
with only 3-6 GB traffic each day to give an specifiy example how good
this works

a part of this backups is a mysql-server for dbmail with
one table-file (innodb) > 10 GB, the whole backup over a
22Mbit wire limited to 800KB/Sec. takes ususally around
30 minutes


--------------enigDA0B754CD97CC8731DFB3987
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.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk70+qcACgkQhmBjz394AnmGIQCdFs0ssKfMT7NqJGRjxxMae47e
fZAAmgIlO/oWgSsDhU8ceGPY1GvIJa1D
=yWiv
-----END PGP SIGNATURE-----

--------------enigDA0B754CD97CC8731DFB3987--