Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 76 10 Older Entries

Displaying posts with tag: Backups (reset)

MySQL 5.1 and InnoDB Hot Backup Gotcha
+1 Vote Up -0Vote Down

Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup, the following error occurred when we ran mysql_upgrade:

mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
ERROR 13 (HY000) at line 311: Can't get stat of './mysql/general_log.CSV' (Errcode: 2)
ERROR 13 (HY000) at line 316: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)
FATAL ERROR: Upgrade failed

The problem is that in MySQL 5.1, it is possible to log the slow query log and general log to tables in the mysql schema

  [Read more...]
Just how useful are binary logs for incremental backups?
+1 Vote Up -0Vote Down

We've written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup.  Let me make up some numbers for the purposes of this example:

  • We have 2 Servers in a Master-Slave topology.
  • The database size is 100 GB (same tables on each).
  • The slave machine barely keeps up with the master (at 90% capacity during peak, 75% during offpeak)
  • The peak window is 12 hours, the offpeak window is 12 hours.

Provided that the backup method was raw data files, it shouldn't take much more than 30 minutes to restore 100GB (50MB/s), but to replay one day of binary

  [Read more...]
Improving InnoDB recovery time
+3 Vote Up -0Vote Down

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see:

http://bugs.mysql.com/bug.php?id=29847

http://dammit.lt/2008/10/26/innodb-crash-recovery/

This is problem when your InnoDB crashes, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup)

In this is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads.
MySQL params are:

PLAIN TEXT CODE:
  • innodb_buffer_pool_size=16G
  • innodb_log_files_in_group=3
  • innodb_log_file_size=512M
  • So let's take




      [Read more...]
    xtrabackup-0.8
    +1 Vote Up -0Vote Down

    Dear community,

    The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download.

    Key features:

    tar4ibd is made to be sure that read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted, and we suspect tar can do read of pages in time when they changed. So we patches libtar to make read consistent.

    Export is added to support moving

      [Read more...]
    xtrabackup-0.7 (RC)
    +0 Vote Up -0Vote Down

    We announce next version of our xtrabackup tool and we consider it stable enough to put label RC on it.

    Changelist includes:

    - use O_DIRECT by default for handling InnoDB files
    - use posix fadvise call to disable OS caching of copying files
    - disable recovery of double buffer

    Also we added binary builds for FreeBSD 7 64bit platform

    You can download current binaries (64bit) RPM for RHEL4 and RHEL5 (compatible with CentOS also), DEB for Debian/Ubuntu, tar.gz for Mac OS / Intel and .tar.gz for FreeBSD 7:
    http://www.percona.com/mysql/xtrabackup/0.7/.
    By the same link you can find general .tar.gz with binaries which can be run on any modern Linux distribution.
    By the same link you can download source code if you do not want to deal with bazaar and Launchpad.

    The






      [Read more...]
    Hint: throttling xtrabackup
    +0 Vote Up -0Vote Down

    Using xtrabackup for copying files can really saturate your disks, and that why we made special option --throttle=rate to limit rate of IO per second. But it really works when you do local copy.
    What about stream backup ? Even you copy just to remote box with
    innobackupex --stream=tar | ssh remotebox "tar xfi -"
    , read may be so intensive so your mysqld feels impact, slave getting behind, etc...

    For this there is a nice small utility - pv .

    With pv you run:
    innobackupex --stream=tar | pv -q -L10m | ssh remotebox "tar xfi -"

    and it will limit channel rate to 10 M per second.


    Entry posted by Vadim | No





      [Read more...]
    xtrabackup-0.6
    +0 Vote Up -0Vote Down

    We announce next beta version of our xtrabackup tool.

    Changelist includes:

    - set innodb_fast_shutdown=1 on xtrabackup shutdown
    - set innodb_write_io_threads=10 by default for fast buffer_pool flushing during recovery
    - build xtrabackup with --with-extra-charsets=complex
    Bug #357653: innobackupex-1.5.1 --copy-back fails
    Bug #358194: 2nd-phase is very slow
    Bug #358266: xtrabackup-0.5 dies with SEGV on bad command line arguments
    Bug #359341: innobackupex still does not read defaults-file

    You can download current binaries RPM for RHEL4 and RHEL5 (compatible with CentOS also), DEB for Debian/Ubuntu and tar.gz for Mac OS / Intel 64bit there:
    http://www.percona.com/mysql/xtrabackup/0.6/.
    By the same link you can find general .tar.gz with binaries which can be run on







      [Read more...]
    xtrabackup-0.5, bugfixes, incremental backup introduction
    +0 Vote Up -0Vote Down

    I am happy to announce next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup.

    Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output:

    PLAIN TEXT CODE:
  • The latest check point (for incremental): '1319:813219999'
  • >> log scanned up to (1319 813701532)
  • Transaction log of lsn (1318 3034677302) to (1319 813701532) was copied.
  • 090404 06:03:29  innobackupex: All tables unlocked
  • 090404 06:03:29  innobackupex: Connection to database server closed
  •  
  • innobackupex: Backup created in
  •   [Read more...]
    xtrabackup-0.4, going beta, progress meter
    +0 Vote Up -0Vote Down

    We added some new features to our backup tool, namely:

    • Now we can handle log file taken during backup with size exceeding 4GB, it may happen if backup takes too long and you have a lot of updates on InnoDB tables
    • Progress meter during recovery step, now you can see what percentage of log file was handled
    PLAIN TEXT CODE:
  • InnoDB: Doing recovery: scanned up to log sequence number 1316 3688693248 (34 %)
  • ...
  • InnoDB: Doing recovery: scanned up to log sequence number 1316 4113366528 (68 %)
  • InnoDB: Doing recovery: scanned up to log sequence number 1316 4117548544 (68 %)
  • Also we did extensive testing and fixed bugs, so now we consider current state

      [Read more...]
    xtrabackup-0.3, binaries and stream backup
    +0 Vote Up -0Vote Down

    We are coming with next version of xtrabackup - online backup solution for MySQL 5.0 / 5.1 and InnoDB standard version, plugin modification and XtraDB. We still consider it as alpha version, though it shows perfect stable results in our tests.

    Let me address two often asked question about xtrabackup:
    1) Does it work only with XtraDB or with InnoDB also ?
    A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online backup.

    2) Do we need to run patched MySQL, because the build instruction mentions the patch for MySQL ?
    A: xtrabackup can be run with any version of MySQL: community release,



      [Read more...]
    10 Newer Entries Showing entries 31 to 40 of 76 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.