Hi Peter, > > > * 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. > > Martin, > > 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. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
