From: Reindl Harald
Date: March 21 2011 11:44am
Subject: Re: Question about Backup
List-Archive: http://lists.mysql.com/mysql/224690
Message-Id: <4D873A08.3030305@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig67609B79182EA18523CE8834"

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

Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since 2009

Am 21.03.2011 12:23, schrieb Pedro Nu=F1ez:
> Hi
>=20
> I need set up a backup strategy  for a mysql database in a ubuntu serve=
r,
> the database will grow up to a 5TB.
> What would be the best option ?? Maybe a script that uses mysqldump?? T=
here
> is a better way to do this?
>=20
> Thanks in advance to all
> Pedro.

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


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

iEYEARECAAYFAk2HOggACgkQhmBjz394AnkZ/QCdFPl7HoCZ+0vIc8zgLanF+FwX
uwAAn0LPoRFi/lNMAOG9L6O44ZnpJTZu
=ssrM
-----END PGP SIGNATURE-----

--------------enig67609B79182EA18523CE8834--