From: Reindl Harald
Date: October 16 2012 8:09pm
Subject: Re: Odd Behavior During Replication Start-Up
List-Archive: http://lists.mysql.com/mysql/228418
Message-Id: <507DBF11.2090000@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig68999F5AF5A24E32153A621A"

--------------enig68999F5AF5A24E32153A621A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 16.10.2012 21:55, schrieb Michael Dykman:
> I'm confused: in the first sentence, you say snapshots are bad (which
> directly contradicts the official MySQL documentation), and in the
> second sentence you say rsync is good.  Why would an rsync of a file
> system snapshot not be good enough?  By the way: I forgot to mention
> that I also did create a snapshot when the MySQL server on db-01 was
> actually shut down, and got the same sort of results.

i said nothing about rsync a snapshot!

* rsync HOT while runnining master
* stop master
* rsync cold to get the copy synchron

the two rsync runs because it minimizes downtime nearly to zero
i do not trust any FS snapshot in this context
i do not trust any documentation in this context

fact is if you stop the master there are REALLY no open files
and that is why i do two rsync runs, the sconed one only have
to care about diffs for changed files between both ones


--------------enig68999F5AF5A24E32153A621A
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/

iEYEARECAAYFAlB9vxEACgkQhmBjz394AnkzbwCfZmwRUlIA4XvqXOZir8phuqLf
KJIAoIzKLuDQCyuMWSFfJlXXfBcpqUW6
=fqYT
-----END PGP SIGNATURE-----

--------------enig68999F5AF5A24E32153A621A--