Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 4

Displaying posts with tag: myloader (reset)

Mydumper now with MyISAM consistent snapshots!
+0 Vote Up -0Vote Down
Mydumper 0.2.2 has been released today with a number of fixes and new features.  The one that most people have been asking for is consistent snapshots for non-InnoDB tables (such as MyISAM).  We have been able to achieve this without locking the database for the entire backup using the following method:

  • Flush tables with read lock (and start transaction with consistent snapshot on all threads)

  • Dump non-InnoDB

  • Start InnoDB dump

  • When non-InnoDB dump has finished (whilst InnoDB is dumping) unlock tables





  •   [Read more...]
    Mydumper now with MyISAM consistent snapshots!
    +4 Vote Up -0Vote Down

    Mydumper 0.2.2 has been released today with a number of fixes and new features.  The one that most people have been asking for is consistent snapshots for non-InnoDB tables (such as MyISAM).  We have been able to achieve this without locking the database for the entire backup using the following method:

  • Flush tables with read lock (and start transaction with consistent snapshot on all threads)
  • Dump non-InnoDB
  • Start InnoDB dump
  • When non-InnoDB dump has finished (whilst InnoDB is dumping) unlock tables
  • Profit
  • I have also started work on Drizzle support this week.  The Drizzle support is not entirely complete

      [Read more...]
    Mydumper now with myloader!
    +0 Vote Up -0Vote Down
    It has only been a few days since the 0.2.0 release of mydumper but there have been some big changes since then.  I will try and go over them all here.

    Mydumper 0.2.1


    Mydumper 0.2.1 has been released today, many thanks for all those who have been testing the trunk source, the feedback has gone a long way to making fixes and improvements to mydumper.  You can download the source for it here.

    Myloader


    A few days ago Mark Callaghan asked about restoring mydumper backups. 



      [Read more...]
    Mydumper now with myloader!
    +6 Vote Up -0Vote Down

    It has only been a few days since the 0.2.0 release of mydumper but there have been some big changes since then.  I will try and go over them all here.

    Mydumper 0.2.1

    Mydumper 0.2.1 has been released today, many thanks for all those who have been testing the trunk source, the feedback has gone a long way to making fixes and improvements to mydumper.  You can download the source for it here.

    Myloader

    A few days ago Mark Callaghan asked about restoring mydumper backups.  There is of course the great

      [Read more...]
    Showing entries 1 to 4

    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.