Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: J Trahair (j.trahairforeversoftware.co.uk)
Date: Wed Nov 28 2007 - 02:51:51 CST
What about the MySQL Administration backup routine, which can be scheduled for a convenient time? No-one has mentioned this one. We use it but perhaps there is something I should know...?
----- Original Message -----
From: B. Keith Murphy
To: Dan Buettner
Cc: David Campbell ; MySql
Sent: Wednesday, November 28, 2007 2:55 AM
Subject: Re: preferred way to backup a 20GB MySQL database
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed. It essentially does a dump with a thread
running (by default) for each CPU core you have. A dual core box will
run two threads and dump roughly twice as fast as a normal mysqldump.
In addition, it compresses the output making it much more compact. He
has renamed the toolkit to Maatkit and it is available at
Also, you might look into using an LVM snapshot to run the copy from.
That way it doesn't interfere with your operations as much. I do that
for some of our production slave servers myself.
Dan Buettner wrote:
> I'd strongly recommend setting up replication, and then taking your backups
> from the replica.
> mysqlhotcopy works great, I used it for years myself, but it does require
> "freezing" your database while the copy happens. And no matter how you do
> it, copying 20 GB takes a little bit of time.
> On Nov 27, 2007 4:35 PM, David Campbell <davecpfc.org> wrote:
>> Andras Kende wrote:
>>> What is the preferred way to backup a 20GB database daily,
>>> without taking offline ?
>>> MySQL 4.1 MyISAM - (will be updated to MySQL 5)
>>> 133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettnergmail.com
editor: MySQL Magazine
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=j.trahairforeversoftware.co.uk