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

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

Am 28.01.2011 22:30, schrieb Robinson, Eric:

> Our current model has been working well since 2006. We will be careful
> to verify the reliability of any proposed changes.=20
>=20
> Have a great day!

this is ok because MyISAM is so simple that you can even without any
flushes make a copy while the server is running and after a "repair table=
"
on the destination machine all tables are useable

With InnoDB it is much difficult because "table spaces"
Eeven with "innodb_file_per_table" there are dependencies
of the table-files and "ibdata1" in the main datadir

If there is only a minimal problem it is possible that mysqld
will not start and if this is a time where you need your backup
really you would like to die :-)

Even if there would be documentaed ways to rsync while the
server is running i would never ever do that because it is
so hot that a simple mysql-bug in a later release could break
it temporarliy and you would not notice this, so you sgould simply
go a safe way

* flush atbles
* rsync while mysqld is running
* stop mysqld
* second rsync

With this steps you can  copy real big databases with a minimum downtime,=

to reduce this again select a local folder as target if your disks are fa=
st
and after mysqld is runnign again you can sync this copy to another machi=
ne
without stress


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

iEYEARECAAYFAk1DOWUACgkQhmBjz394Anl/XgCfQ4CUUQsB5hWrpVozrguVcaXD
7UMAn3DrrGM6GRug/kAwv3026j4T1+df
=0Pot
-----END PGP SIGNATURE-----

--------------enig6315EC6DF3686A7AE6669F21--