On Tue, 2004-02-10 at 08:38, Martijn Tonies wrote:
> > * Assuming that my points below regarding performance are correct (I'm
> > sure that Heikki will stand by InnoDB and back up anyone preaching it's
> > performance benefits), the lower hardware costs are an important factor
> > (as in lower for a given performance target).
> Note: when using InnoDB in 24x7 environments, you need to purchase an
> additional hot-backup tool to do your backups. Not expensive at all though.
This is not exactly the case. There are several ways to get Innodb hot
and consistent backup. Commercial Innodb Hot Backup tool by Innobase Oy
is the easiest to use and fastest.
Alternatively you can use LVM (or similar tool) to get the consist read
only snapshot and use it as backup or use
"mysqldump --single-transaction" to get consistent text backup.
As Innob has versioning these selects will not lock anything.
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)