If you use InnoDB then the InnoDB Hot-backup tool works very well. It's not
free, but its inexpensive and if you are in an environment where you need to do
large fast hot backups you will probably find it well worthwhile.
We normally do backups as follows:
Production Server A <-> Production Server B
|
\/
Backup Server
(The arrows above are replication)
Where in the above A and B replicate to each other and both are live for
production use. Then the backup server replicates off of A but is never used
in production. We then once a week do a full mysqldump of the backup and call
that our full backup. Nightly we rotate the binary logs for incremental
backups on the backup server and store them with the full dump for the week.
Using that model you never need a 'hot backup' as you can take the backup
server offline take a backup, then bring it back and let it catch up. However,
when you do need a hot-backup is in the event the backup server fails or the db
corrupts. Then we use InnoDB hot-backup to take a live snapshot off of
Production Server A and restore Backup Server from it and restart replication
consistently. This model works very well and has been in use for more than a
year on a 60gig+ database. It does have the cost of requiring some extra
hardware of course.
John A. McCaskey
-----Original Message-----
From: Glennie Vignarajah [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 10:50 AM
To: mysql@lists.mysql.com
Subject: Re: Backing up live MySQL Databases
Le Thursday 16 June 2005 17:06, Jeff McKeon("Jeff McKeon"
<[EMAIL PROTECTED]>) disait:
Hello,
> Anyone using any third party products like Arkeia that enable you
> to do a live backup of MySQL database?
I've tried Arkeia few months ago. The online backup and restore of
MySql databases worked well.
> I'm searching for a backup solution for our new data center and
> would like to here what other people are using for MySQL.
Net Valut from bakbone (www.bakbone.com) makes also online backup
(I've not tried MySql hot backup yet). There is a demo version so
you can give try.
With my little experience of both products, I can say that they are
both quite user friendly and can handle Linux/Solaris/Windows
clients (but Arkeia Server needs to installed on a Linux machine)...
We chosed NetVault beacause it can backup our INFORMIX server (which
can't be switch to Mysql yet :-( ) and LDAP servers online!
--
Glennie
"L'ambition est le dernier refuge de l'échec"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
