Results 1 to 7 of 7

Thread: MySQL backup method options

  1. #1

    Default MySQL backup method options

    Most importantly, I need the following features with my backup solution:

    -Hot, or almost hot
    -Fast/low overhead
    -Support for InnoDB exclusively

    I want to use ZRM. The SQL server is on a Debian machine w/o LVM. As far as the methods that ZRM implement to accomplish backups, what is my best bet?

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by tgordon View Post
    Most importantly, I need the following features with my backup solution:

    -Hot, or almost hot
    -Fast/low overhead
    -Support for InnoDB exclusively

    I want to use ZRM. The SQL server is on a Debian machine w/o LVM. As far as the methods that ZRM implement to accomplish backups, what is my best bet?
    ZRM can do hot and almost hot backups of Innodb using mysql replication and
    snapshot respectively. Snapshot interface allows support for other methods
    of filesystem and volume snapshots other than LVM.

    Please take a look at ZRM backup and recovery performance numbers posted by Dmitri - [url]http://forums.zmanda.com/showthread.php?t=489&highlight=mysql+paper[/url]

    You should download and try ZRM ([url]http://www.zmanda.com/download-zrm.php[/url])
    so that you can get accurate performance numbers in your configuration. ZRM's application performance report will provide information on ZRM's application
    impact.

    Paddy

  3. #3

    Default

    Thanks much!

  4. #4

    Default

    Quote Originally Posted by paddy View Post
    ZRM can do hot and almost hot backups of Innodb using mysql replication and
    snapshot respectively. Snapshot interface allows support for other methods
    of filesystem and volume snapshots other than LVM.
    What methods are these exactly? Could you point me to some documentation perhaps?

  5. #5
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by tgordon View Post
    What methods are these exactly? Could you point me to some documentation perhaps?
    Snapshot plugin interface is described in the [URL=http://wiki.zmanda.com/index.php/Snapshot_Plugin]wiki[/URL]. Please use
    snapshot-plugin variable in the mysql-zrm.conf to configure another plugin.

    If you need help in writing a filesystem or volume snapshot plugin, please ask.

    We are working on adding more information to the wiki.

    Thanks,
    Paddy

  6. #6

    Default

    So no snapshot-plugin has been implemented? There's just an interface for one currently? I don't quite understand.

  7. #7
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by tgordon View Post
    So no snapshot-plugin has been implemented? There's just an interface for one currently? I don't quite understand.

    LVM snapshots uses this interface. You will see more plugins using this interface in future. Developing a filesystem or volume manager snapshot on your own is easy.

    Paddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •