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.
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. -- Peter Zaitsev, Senior Support Engineer MySQL AB, www.mysql.com Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
