List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 11 2004 7:01am
Subject:Re: SQL2000 and MySql
View as plain text  
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

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