> > > * Assuming that my points below regarding performance are correct (I'm
> > > sure that Heikki will stand by InnoDB and back up anyone preaching
> > > performance benefits), the lower hardware costs are an important
> > > (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
> 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.
Interesting - thanks for setting me straight here.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL