MySQL Backups with Symantec NetBackup
Symantec NetBackup now enables live backup of MySQL, using two solutions provided by Zmanda:
Zmanda MySQL Agent for NetBackup: Backup MySQL databases directly from MySQL servers to your NetBackup server. This backup method does not need a proxy server and, for many backup methods, does not require disk space for transient storage of backup images. MySQL backups and schedules are managed via the NetBackup GUI.
Zmanda Recovery Manager (ZRM) for MySQL, with NetBackup Option: This solution gives you the full functionality of Zmanda Recovery Manager for MySQL, including an intuitive search interface for MySQL binary logs to quickly identify the location for point-in-time recovery. MySQL DBAs can choose to keep a copy of their MySQL backups on the ZRM server, providing them with a quicker recovery process specific to MySQL, independent of the corporate backup and recovery infrastructure. Zmanda Recovery Manager provides a scalable interface to manage global backup and recovery of thousands of MySQL databases.
MySQL Agent for NetBackup
MySQL Agent for NetBackup from Zmanda is deeply integrated and certified with NetBackup 7.x using the XBSA API. The agent supports backup of MySQL versions 4.1 and 5.x. Both MySQL Community and Enterprise Editions are supported.
This agent does full, incremental and differential backups of MySQL. Data is backed up to media of your choice, managed by NetBackup. You can monitor backup and restoration of MySQL databases using the NetBackup Operations Manager.
Supported MySQL versions:
MySQL 4.1 and 5.x (Community Edition or Enterprise Edition). SkySQL Enterprise and Percona Servers with equivalent versions are also supported.
Supported OS for MySQL Servers:
Red Hat Enterprise Linux (RHEL) 5.x and 6.x, CentOS 5.x and 6.x, SUSE Linux Enterprise Server (SLES) 10.x and 11.x
Requirements on MySQL Server:
NetBackup Standard or Enterprise Client 7.x for Linux. Perl. NetBackup Application & Database Pack is not required.
MySQL Agent for NetBackup is available through Zmanda and several Symantec resellers around the world. This agent is sold in two ways: (1) Zmanda Subscription: MSRP $500 per year per protected MySQL server. This is annual subscription price which comes with Zmanda's Premium Level Support. or (2) Perpetual License: MSRP $850 per MySQL server. Support contract sold separately. Price is same across all Hardware Tiers.This price also includes the LVM, VxFS and EBS Snapshot options. Snapshot options for NetApp, EMC and BlueArc are sold separately.
- Demonstration of MySQL Agent for MySQL (video)
Zmanda Recovery Manager for MySQL - NetBackup Option (ZRM-NetBackup Option)
Zmanda Recovery Manager (ZRM) for MySQL - NetBackup Option allows IT managers to implement live backup of their MySQL databases with seamless integration with NetBackup. ZRM does full and incremental backups of MySQL. Data is backed up to media of your choice, managed by NetBackup.
Combined with Zmanda Recovery Manager for MySQL, this option provides full functionality of a database backup agent for NetBackup. This solution is designed by MySQL experts and system backup veterans at Zmanda, and meets the needs of both the MySQL DBAs (e.g. point-in-time recovery of their databases) and System Administrators (e.g. managing retention policies of data archives).
This option, along with NetBackup Linux or Solaris Client, only needs to be installed on the ZRM Server running on a Linux or Solaris server. This server can centrally protect multiple MySQL databases running on any operating system in your environment.
You can schedule full and incremental backups of MySQL based on your system resources and backup policies. You can choose to use scheduler of NetBackup or ZRM in order to transfer data to backup media.
You will have the option of using various methods to backup MySQL, including Snapshots based backups. Snapshots are the fastest mechanism to backup a large and active MySQL database. In addition ZRM intelligently takes incremental backups and correlates them with appropriate full backups during recovery.
Easy to Manage:
Zmanda Management Console makes it intuitive for you to configure and manage backup and restore of your MySQL databases from a browser from anywhere in the world. You also have access to powerful command line interface for scripting purposes.
This solution supports all MySQL Storage Engines, including InnoDB and MyISAM
Visual Log Analyzer:
MySQL DBAs can use the built-in visual log analyzer to search logs of their databases to quickly identify desired point of recovery (e.g. just before a bad transaction was run by accident).
This option needs a subscription for ZRM server on Linux or Solaris and a license for NetBackup client for Linux or Solaris. You will need to get a subscription for ZRM for every MySQL server you are protecting — but these servers do not need the NetBackup client or the ZRM-NetBackup Option.
Interested in purchasing or evaluating NetBackup Option
? Contact Zmanda Sales at:
See also: Postgres Backups with Symantec NetBackup