--001636920a1ac417af049efc5c7f
Content-Type: text/plain; charset=ISO-8859-1
Hi
I need set up a backup strategy for a mysql database in a ubuntu server,
the database will grow up to a 5TB.
What would be the best option ?? Maybe a script that uses mysqldump?? There
is a better way to do this?
Thanks in advance to all
Pedro.
--001636920a1ac417af049efc5c7f--
--------------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üßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 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--
Hi, =20
The statement like 'I need to back up a 5T database' is not a backup =
strategy. It is intention. There are some specifics that have to be =
determined to work out a strategy. Going from there, the backup =
solution can be chosen. The examples of questions one typically asks =
when determining a strategy are as follows:
1. What is my allowed data loss in time units, f.e. hours and minutes?=20=
2. What are my availability requirements for the data to be brought up, =
that is how quickly I want to recover from backup?
3. Do I need to be able to recover as of discrete points of time or as =
of any continuous time range?
4. What are my availability requirements during backups? =20
Tx
Karen.
On Mar 21, 2011, at 4:44 AM, Reindl Harald wrote:
> 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
>=20
> 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 =
server,
>> the database will grow up to a 5TB.
>> What would be the best option ?? Maybe a script that uses mysqldump?? =
There
>> is a better way to do this?
>>=20
>> Thanks in advance to all
>> Pedro.
>=20
> --=20
>=20
> Mit besten Grüßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / software-development / cms-solutions
> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
> icq: 154546673, http://www.thelounge.net/
>=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
--Boundary_(ID_Y2IGgldvbF7JHehK31HCHQ)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
That would be the last question :-) Suppose we worked out strategy, =
lined up the solutions along with their costs and then compare them with =
our budget. That would be easy to find the one we can afford, and we =
will know what we could dream about :-). =20
On Mar 21, 2011, at 11:28 AM, Singer X.J. Wang wrote:
> Also, very important but often not asked:
>=20
> 1) What's my budget?
>=20
>=20
> On Mon, Mar 21, 2011 at 14:24, Karen Abgarian
> Hi,
>=20
> The statement like 'I need to back up a 5T database' is not a backup =
strategy. It is intention. There are some specifics that have to be =
determined to work out a strategy. Going from there, the backup =
solution can be chosen. The examples of questions one typically asks =
when determining a strategy are as follows:
>=20
> 1. What is my allowed data loss in time units, f.e. hours and =
minutes?
> 2. What are my availability requirements for the data to be brought =
up, that is how quickly I want to recover from backup?
> 3. Do I need to be able to recover as of discrete points of time or =
as of any continuous time range?
> 4. What are my availability requirements during backups?
>=20
>=20
> Tx
> Karen.
>=20
>=20
> On Mar 21, 2011, at 4:44 AM, Reindl Harald wrote:
>=20
> > 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
> >>
> >> I need set up a backup strategy for a mysql database in a ubuntu =
server,
> >> the database will grow up to a 5TB.
> >> What would be the best option ?? Maybe a script that uses =
mysqldump?? There
> >> is a better way to do this?
> >>
> >> Thanks in advance to all
> >> Pedro.
> >
> > --
> >
> > Mit besten Grüßen, Reindl Harald
> > the lounge interactive design GmbH
> > A-1060 Vienna, Hofmühlgasse 17
> > CTO / software-development / cms-solutions
> > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
> > icq: 154546673, http://www.thelounge.net/
> >
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dwang@singerwang.com
>=20
>=20
> --
> The best compliment you could give Pythian for our service is a =
referral.
>=20
--Boundary_(ID_Y2IGgldvbF7JHehK31HCHQ)--
You are assuming that the database is one table of 5.000 gigabyte, and not 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
----- Original Message -----
> From: "Reindl Harald"
> To: mysql@lists.mysql.com
> Sent: Monday, 21 March, 2011 12:44:08 PM
> Subject: Re: Question about Backup
>
> 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
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Why, if they shut down the slave, it will be quite consistent. Only that this technique is not as much of the 21th century, but is like 30 years old.
Placing locks is about the same as shutting it down.
On Mar 22, 2011, at 6:01 AM, Johan De Meersman wrote:
>
> You are assuming that the database is one table of 5.000 gigabyte, and not 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
>
>
> ----- Original Message -----
>> From: "Reindl Harald"
>> To: mysql@lists.mysql.com
>> Sent: Monday, 21 March, 2011 12:44:08 PM
>> Subject: Re: Question about Backup
>>
>> 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
>>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=abvk@apple.com
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
On Tue, March 22, 2011 10:32, Karen Abgarian wrote:
> Why, if they shut down the slave, it will be quite consistent. Only that
> this technique is not as much of the 21th century, but is like 30 years
> old.
> Placing locks is about the same as shutting it down.
>
Ah, but if you have the dump function do the locking it will also remember
to "restart" it when its done.
> On Mar 22, 2011, at 6:01 AM, Johan De Meersman wrote:
>
>>
>> You are assuming that the database is one table of 5.000 gigabyte, and
>> not 5.000 tables of one gigabyte; and that the backup needs to be
>> consistent :-p
>>
>>
>> ----- Original Message -----
>>> From: "Reindl Harald"
>>> To: mysql@lists.mysql.com
>>> Sent: Monday, 21 March, 2011 12:44:08 PM
>>> Subject: Re: Question about Backup
>>>
>>> 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
>>>
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=abvk@apple.com
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mussatto@csz.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org