Comments for Zmanda Team Blog http://www.zmanda.com/blogs Wed, 19 Jun 2013 08:38:59 +0000 http://wordpress.org/?v=2.7.1 hourly 1 Comment on What’s New in Amanda Community: Postgres Backups by Dustin J. Mitchell http://www.zmanda.com/blogs/?p=308&cpage=1#comment-58942 Dustin J. Mitchell Thu, 01 Apr 2010 14:45:53 +0000 http://www.zmanda.com/blogs/?p=308#comment-58942 I updated the wiki page as you suggested. Please feel free to make any other changes that you think are appropriate! I updated the wiki page as you suggested. Please feel free to make any other changes that you think are appropriate!

]]> Comment on What’s New in Amanda Community: Postgres Backups by Greg Smith http://www.zmanda.com/blogs/?p=308&cpage=1#comment-58796 Greg Smith Mon, 29 Mar 2010 01:52:30 +0000 http://www.zmanda.com/blogs/?p=308#comment-58796 In your "How To", you might make the examples a bit easier to follow if you update the generic archive_command example: archive_command = 'test ! -f /path/to/archivedir/%f && cp %p /path/to/archivedir/%f' To one that matches the amanda-client.conf you have later: archive_command = 'test ! -f /var/pgsql/archive/%f && cp %p /var/pgsql/archive/%f' Having an archive directory in a subdirectory at the same level as the database's "data" directory is a pretty common PostgreSQL practice. Making the example set consistent and named that way would therefore be suggesting a reasonable practice for people who don't have a directory tree convention yet. In your “How To”, you might make the examples a bit easier to follow if you update the generic archive_command example:

archive_command = ‘test ! -f /path/to/archivedir/%f && cp %p /path/to/archivedir/%f’

To one that matches the amanda-client.conf you have later:

archive_command = ‘test ! -f /var/pgsql/archive/%f && cp %p /var/pgsql/archive/%f’

Having an archive directory in a subdirectory at the same level as the database’s “data” directory is a pretty common PostgreSQL practice. Making the example set consistent and named that way would therefore be suggesting a reasonable practice for people who don’t have a directory tree convention yet.

]]> Comment on Cloud Backup by Cloud Backup II « Zmanda Team Blog http://www.zmanda.com/blogs/?p=129&cpage=1#comment-50866 Cloud Backup II « Zmanda Team Blog Wed, 24 Jun 2009 00:44:39 +0000 http://www.zmanda.com/blogs/?p=129#comment-50866 [...] Cloud Backup Sun Heats Up Cloud Storage [...] [...] Cloud Backup Sun Heats Up Cloud Storage [...]

]]> Comment on Scaling Up: MySQL on NetApp by Mark Callaghan http://www.zmanda.com/blogs/?p=101&cpage=1#comment-33714 Mark Callaghan Tue, 03 Jun 2008 22:05:46 +0000 http://www.zmanda.com/blogs/?p=101#comment-33714 I am curious about the performance of NetApp with MySQL. There are potential pitfalls. First, MyISAM depends on fast read system calls as it does not cache data blocks. What is the speed difference between reading from the OS buffer cache and reading from NetApp? InnoDB has 1 thread for prefetch reads and 1 thread to flush dirty buffer pool pages. Dirty buffer page writes done to the OS buffer cache are fast. What is the difference between that and writing to NetApp? Can someone give the people at Percona a NetApp filer to provide some answers? The Google patch has support for multiple background IO threads. That might help when running with NetApp. We need to get InnoDB to provide that in their plugin. I am curious about the performance of NetApp with MySQL. There are potential pitfalls. First, MyISAM depends on fast read system calls as it does not cache data blocks. What is the speed difference between reading from the OS buffer cache and reading from NetApp? InnoDB has 1 thread for prefetch reads and 1 thread to flush dirty buffer pool pages. Dirty buffer page writes done to the OS buffer cache are fast. What is the difference between that and writing to NetApp?

Can someone give the people at Percona a NetApp filer to provide some answers?

The Google patch has support for multiple background IO threads. That might help when running with NetApp. We need to get InnoDB to provide that in their plugin.

]]> Comment on Highly Scalable MySQL Backups using Snapshots (ZFS or NetApp) by Zmanda Team Blog » Blog Archive » Scaling Up: MySQL on NetApp http://www.zmanda.com/blogs/?p=93&cpage=1#comment-33706 Zmanda Team Blog » Blog Archive » Scaling Up: MySQL on NetApp Tue, 03 Jun 2008 21:00:52 +0000 http://www.zmanda.com/blogs/?p=93#comment-33706 [...] As I had indicated before, we have been working with the engineering team at NetApp to create highly scalable backup and archiving solutions for MySQL. Today we formally announced this joint work. Our MySQL backup product, Zmanda Recovery Manager (ZRM) for MySQL with NetApp SnapShot Manager, meets two crucial design goals for scaling MySQL backups: least impact on the live production applications and quick point-in-time recovery. Database snapshots created by ZRM can also act as source for NetApp SnapMirror software, creating a highly scalable disaster recovery solution. [...] [...] As I had indicated before, we have been working with the engineering team at NetApp to create highly scalable backup and archiving solutions for MySQL. Today we formally announced this joint work. Our MySQL backup product, Zmanda Recovery Manager (ZRM) for MySQL with NetApp SnapShot Manager, meets two crucial design goals for scaling MySQL backups: least impact on the live production applications and quick point-in-time recovery. Database snapshots created by ZRM can also act as source for NetApp SnapMirror software, creating a highly scalable disaster recovery solution. [...]

]]> Comment on Zmanda Recovery Manager 2.1 - Keep those MySQL Databases Zipping by ZUrlocker http://www.zmanda.com/blogs/?p=86&cpage=1#comment-28389 ZUrlocker Fri, 29 Feb 2008 23:40:51 +0000 http://www.zmanda.com/blogs/?p=86#comment-28389 Good job guys, this looks great. I'm really impressed with the snapshot capabilities. --Zack Good job guys, this looks great. I’m really impressed with the snapshot capabilities.

–Zack

]]> Comment on Managing backup of MySQL via iPhone by Zmanda Team Blog » Blog Archive » Zmanda Recovery Manager 2.1 - Keep those MySQL Databases Zipping http://www.zmanda.com/blogs/?p=63&cpage=1#comment-28310 Zmanda Team Blog » Blog Archive » Zmanda Recovery Manager 2.1 - Keep those MySQL Databases Zipping Fri, 29 Feb 2008 00:07:27 +0000 http://www.zmanda.com/blogs/?p=63#comment-28310 [...] Global Management of MySQL databases: One key behavior we observe about MySQL databases is that they tend to propagate rapidly within organizations. Here at Zmanda, I can easily count close to 10 production MySQL databases, both inside and outside our firewall. Maintaining backups of multiple MySQL databases at a single repository tremendously reduces the complexity for DBAs. While we always had some form of remote backup capability, with ZRM 2.1 we now support centralized backup across all storage engines and across all operating systems. Our web based Zmanda Management Console allows this centralized management from anywhere, including from an iPhone! [...] [...] Global Management of MySQL databases: One key behavior we observe about MySQL databases is that they tend to propagate rapidly within organizations. Here at Zmanda, I can easily count close to 10 production MySQL databases, both inside and outside our firewall. Maintaining backups of multiple MySQL databases at a single repository tremendously reduces the complexity for DBAs. While we always had some form of remote backup capability, with ZRM 2.1 we now support centralized backup across all storage engines and across all operating systems. Our web based Zmanda Management Console allows this centralized management from anywhere, including from an iPhone! [...]

]]> Comment on MySQL Online Backup by Ben Krug http://www.zmanda.com/blogs/?p=19&cpage=1#comment-24167 Ben Krug Thu, 13 Dec 2007 05:15:18 +0000 http://www.zmanda.com/blogs/?p=19#comment-24167 Dmitriy - mysqldump is listed as a backup method. It's pretty easy to restore a table from a mysqldump file. Edit the dump file and take the part you want. I've done it many times. Perfect for restoring a table "from a month ago". Dmitriy - mysqldump is listed as a backup method. It’s pretty easy to restore a table from a mysqldump file. Edit the dump file and take the part you want. I’ve done it many times. Perfect for restoring a table “from a month ago”.

]]> Comment on Backup and Recovery Techniques for MySQL Database by Oracle + Open Source » Blog Archive » Webinar: Migrate to MySQL http://www.zmanda.com/blogs/?p=78&cpage=1#comment-24079 Oracle + Open Source » Blog Archive » Webinar: Migrate to MySQL Wed, 12 Dec 2007 00:00:37 +0000 http://www.zmanda.com/blogs/?p=78#comment-24079 [...] The folks over at zmanda who specialize in MySQL backup are doing a webinar on December 13th, this Thursday.  They specifically mention it as relevant for Oracle DBAs or anyone moving to MySQL.  Looks to be an interesting event. addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2007%2F12%2F11%2Fwebinar-migrate-to-mysql%2F'; addthis_title = 'Webinar%3A+Migrate+to+MySQL'; addthis_pub = ''; [...] [...] The folks over at zmanda who specialize in MySQL backup are doing a webinar on December 13th, this Thursday.  They specifically mention it as relevant for Oracle DBAs or anyone moving to MySQL.  Looks to be an interesting event. addthis_url = ‘http%3A%2F%2Foracleopensource.com%2F2007%2F12%2F11%2Fwebinar-migrate-to-mysql%2F’; addthis_title = ‘Webinar%3A+Migrate+to+MySQL’; addthis_pub = ”; [...]

]]> Comment on MySQL Online Backup by Zmanda Team Blog » Blog Archive » Backup and Recovery Techniques for MySQL Database http://www.zmanda.com/blogs/?p=19&cpage=1#comment-23952 Zmanda Team Blog » Blog Archive » Backup and Recovery Techniques for MySQL Database Sat, 08 Dec 2007 21:33:31 +0000 http://www.zmanda.com/blogs/?p=19#comment-23952 [...] A good pre-read for this webinar would be Paddy’s blog on online MySQL Backup [...] [...] A good pre-read for this webinar would be Paddy’s blog on online MySQL Backup [...]

]]>