The backup set is a grouping mechanism that simplifies and optimizes backing up MySQL databases, and tables that are accessible for a MySQL server or is a part of MySQL cluster. It lets an administrator define a set of backup policies (what, how, where and when) to automatically schedule different backup runs.
All ZMC actions (backup, restore, reporting, and monitoring) are performed in the context of backup sets.
A backup set cannot include more than one MySQL server, unless those servers form a cluster. A backup set can include one or more databases. When selecting individual tables as backup sources, you must select a single database, then the tables it contains. A single backup set cannot contain tables from multiple databases.
Multiple backup sets are useful for protecting a large number of systems with different backup requirements, but many organizations with less complex backup requirements can define a single backup set to meet their needs. For example, on a network that includes several databases with high transaction rate along with other databases that change more slowly, you would probably want to create one backup set for the more active databases, and another backup set for the less active ones.
A backup set is defined by the following properties:
Multiple backup set configurations
ZRM for MySQL & MariaDB employs multiple levels of default inheritance to simplify the process of administering multiple backup sets:
This is the first page of Zmanda Management Console (see below figure). The left panel can be used to create a new backup set. The right panel is the backup set dash board that shows the list of backup sets, status of the backup set backups and which MySQL server is being backed up.
Backup Set Name
The list of backup sets configured on the ZRM server. They can be sorted. You can select a backup set by clicking on the name.
Last Backup Level
The level of backup performed last for the backup set. 0 means full backup. 1 means log incremental or differential or chained differential backup.
Last Backup Date stamp
Date and time of last backup performed for the backup set. The green icon indicates the last backup was successful. The Red icon indicates last backup was a failure and the backup set needs attention.
Host
Each backup set is associated with a MySQL server. The host name or IP address of the MySQL server.