Results 1 to 5 of 5

Thread: Mixed MySQL / filesystem backups

  1. #1

    Default Mixed MySQL / filesystem backups

    Hello,

    I'm configuring a backup environment where I need to handle both general filesystem data and MySQL databases. ZRM for MySQL seems to be exactly what I need to backup the MySQL databases, but it also looks as though it may be MySQL specific. It seems to me that ZRM is essentially Amanda with extra logic for handling the peculiarities of MySQL databases. Can I run an Amanda server and have it call ZRM on my MySQL servers as part of its normal backup procedure? How would I configure this in the disklist? Alternatively, can I configure ZRM to call Amanda clients?

  2. #2

    Default

    Quote Originally Posted by alex View Post
    Hello,

    I'm configuring a backup environment where I need to handle both general filesystem data and MySQL databases. ZRM for MySQL seems to be exactly what I need to backup the MySQL databases, but it also looks as though it may be MySQL specific. It seems to me that ZRM is essentially Amanda with extra logic for handling the peculiarities of MySQL databases. Can I run an Amanda server and have it call ZRM on my MySQL servers as part of its normal backup procedure? How would I configure this in the disklist? Alternatively, can I configure ZRM to call Amanda clients?
    ZRM is MySQL backup and recovery program and does backups to disks. You
    can backup the ZRM backup images using Amanda along with your filesystem
    backups.

    More tighter integration will be available with Amanda [URL=http://wiki.zmanda.com/index.php/Application_API]application API[/URL] is implemented.

    Paddy
    [URL=http://amanda.zmanda.com/]Amanda backup and recovery [/URL]
    [URL=http://www.zmanda.com/backup-mysql.html]MySQL backup and recovery[/URL]

  3. #3

    Default

    Quote Originally Posted by paddy View Post
    ZRM is MySQL backup and recovery program and does backups to disks. You
    can backup the ZRM backup images using Amanda along with your filesystem
    backups.
    Hmm, I was hoping to avoid this situation as we're dealing with ~500-750 gb databases. I'll have to put some thought into how I want to handle this.

    Quote Originally Posted by paddy View Post
    More tighter integration will be available with Amanda [URL=http://wiki.zmanda.com/index.php/Application_API]application API[/URL] is implemented.
    Thanks, I'll keep an eye on it.

  4. #4

    Default

    Quote Originally Posted by alex View Post
    Hmm, I was hoping to avoid this situation as we're dealing with ~500-750 gb databases. I'll have to put some thought into how I want to handle this.
    What is the current bottleneck? What are you using to backup your databases now?

    Paddy
    [URL=http://amanda.zmanda.com/]Amanda backup and recovery [/URL]
    [URL=http://www.zmanda.com/backup-mysql.html]MySQL backup and recovery[/URL]

  5. #5

    Default

    Quote Originally Posted by paddy View Post
    What is the current bottleneck? What are you using to backup your databases now?

    Paddy
    I just wanted to avoid having ZRM keep its full/incremental backups around on disk and then have Amanda do its own full/incremental backups of that data - it seems like an inefficient use of storage space to me. The current mode of backup is "we have a replication slave".

Posting Permissions

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