From: Reindl Harald
Date: January 25 2011 3:24pm
Subject: Re: InnoDB and rsync
List-Archive: http://lists.mysql.com/mysql/224218
Message-Id: <4D3EEB42.1050003@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig5258138AD4F0B639DFA73B84"

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


Am 25.01.2011 15:56, schrieb Johan De Meersman:
>> jesus christ nobody cares if they are binary replica as long
>> as the data is consistent and ident
>>
>=20
> Actually, I can see this being an issue if you're using LVM snapshot ba=
ckups
> or another similar technique - if the datafiles aren't all identical yo=
u
> won't be able to restore to any machine from a single backup.

Where exactly do you see any problem?

* the master writes his bin-log in row format
* the slaves writes his relay-log and managing inserts updates
* lvm makes a snapshot of relay-log / datafiles

There is none and if there could be one LVM must be broken
because a snapshot has to be consistent

So if you stop the slave, make the snahpshot and start the slave
again there are all buffers written to the vfs-layer and the snapshot
must have a defined state.

Only if the db-server is running and have some data in memory cache
you could have any troubles and that is why not copy the files
as long the server is running

Nobody out there makes a copy of database files while the server
is running, really nobody!

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


--------------enig5258138AD4F0B639DFA73B84
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 Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk0+60IACgkQhmBjz394AnmguwCfXof+QYGGX3dw2Oa9/OXFSban
7JIAnR6gZnqapj8k7j33OCKc0sA7kiPx
=foD/
-----END PGP SIGNATURE-----

--------------enig5258138AD4F0B639DFA73B84--