From: Reindl Harald
Date: January 28 2011 8:31pm
Subject: Re: InnoDB and rsync
List-Archive: http://lists.mysql.com/mysql/224245
Message-Id: <4D432797.4030102@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig7F06EE4E6D17376EE4A2EFD9"

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

Am 28.01.2011 17:04, schrieb Robinson, Eric:

> Just refreshing this topic a bit. Can anyone confirm that FLUSH TABLES
> WITH READ LOCK is sufficient to quiesce the InnoBD background threads
> per Shawn's message above?=20

Damned start your brain, read documentations and hear what peopole say

http://dev.mysql.com/doc/refman/5.1/en/alter-table-problems.html

> If you use ALTER TABLE on a transactional table or if you are using Win=
dows or
> OS/2, ALTER TABLE unlocks the table if you had done a LOCK TABLE on it.=
 This
> is done because InnoDB and these operating systems cannot drop a table =
that is
> in use.

And you will build your business on a hotcopy with external tools beause
you do not trust replication? laughable!

Do what you want, but dont come back and cry if all goes down
You were told in which way you can use rsync with minimum downtime
or that replication can be used to stop only salves for a short time
and you are acting like a child "mama i will do what i said the whole tim=
e"


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

iEYEARECAAYFAk1DJ5gACgkQhmBjz394Ann3iACcDLqNSVWx5xhxWhHglzgjq6Rk
g1gAn0Liax4bw4q+aC1MJTv01/kOsHGI
=9eqW
-----END PGP SIGNATURE-----

--------------enig7F06EE4E6D17376EE4A2EFD9--