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
&g
at 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:
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 thi
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 :-).
On Mar 21, 2011, at 11:28 AM, Singer X.
Hi,
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 determinin
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 N
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.
