List:General Discussion« Previous MessageNext Message »
From:Peter Zaitsev Date:February 10 2004 6:57pm
Subject:Re: SQL2000 and MySql
View as plain text  
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/

Thread
SQL2000 and MySqlAubais309 Feb
  • Re: SQL2000 and MySqlMartijn Tonies9 Feb
Re: SQL2000 and MySqlPeter J Milanese9 Feb
Re: SQL2000 and MySqlMartijn Tonies9 Feb
  • Re: SQL2000 and MySqlChris Nolan10 Feb
    • Re: SQL2000 and MySqlEd Leafe11 Feb
      • Re: SQL2000 and MySqlChris Nolan12 Feb
        • Re: SQL2000 and MySqlEd Leafe12 Feb
          • Re: SQL2000 and MySqlChris Nolan12 Feb
            • Re: SQL2000 and MySqlEd Leafe12 Feb
Re: SQL2000 and MySqlMartijn Tonies10 Feb
  • Re: SQL2000 and MySqlChris Nolan10 Feb
Re: SQL2000 and MySqlMartijn Tonies10 Feb
  • Re: SQL2000 and MySqlPeter Zaitsev10 Feb
  • Re: SQL2000 and MySqlChris Nolan11 Feb
    • Re: SQL2000 and MySqlJochem van Dieten11 Feb
      • Re: SQL2000 and MySqlChris Nolan11 Feb
Re: SQL2000 and MySqlMartijn Tonies11 Feb
Re: SQL2000 and MySqlMartijn Tonies11 Feb