Skip to main content
SnapCenter Software 6.0

Create backup policies for MySQL

Contributors netapp-nsriram netapp-soumikd
PDFs

Before you use SnapCenter to back up MySQL resources, you must create a backup policy for the resource or resource group that you want to back up. A backup policy is a set of rules that governs how you manage, schedule, and retain backups.

Before you begin

  • You must have defined your backup strategy.

    For details, see the information about defining a data protection strategy for MySQL databases.

  • You must have prepared for data protection by completing tasks such as installing SnapCenter, adding hosts, setting up storage system connections, and adding resources.

  • The SnapCenter administrator must have assigned the SVMs for both the source and destination volumes to you if you are replicating snapshots to a mirror or vault.

    Additionally, you can specify replication, script, and application settings in the policy. These options saves time when you want to reuse the policy for another resource group.

About this task

  • SnapLock

    • If 'Retain the backup copies for a specific number of days' option is selected, then the SnapLock retention period must be lesser than or equal to the mentioned retention days.

    • Specifying a snapshot locking period prevents deletion of the snapshots until the retention period expires. This could lead to retaining a larger number of snapshots than the count specified in the policy.

    • For ONTAP 9.12.1 and below version, the clones created from the SnapLock Vault snapshots as part of restore will inherit the SnapLock Vault expiry time. Storage admin should manually cleanup the clones post the SnapLock expiry time.

Note Primary SnapLock settings are managed in SnapCenter backup policy and the secondary SnapLock settings are managed by ONTAP.
Steps

  1. In the left navigation pane, click Settings.

  2. In the Settings page, click Policies.

  3. Click New.

  4. In the Name page, enter the policy name and description.

  5. In the Policy type page, perform the following:

    1. Select storage type.

    2. In the Custom backup settings section, provide any specific backup settings that have to be passed to the plug-in in key-value format.

      You can provide multiple key-values to be passed to the plug-in.

  6. In the Snapshot page, specify the schedule type by selecting On demand, Hourly, Daily, Weekly, or Monthly.

    Note You can specify the schedule (start date, end date, and frequency) for the backup operation while creating a resource group. This enables you to create resource groups that share the same policy and backup frequency, but also enables you to assign different backup schedules to each policy.
    backup seting
    Note If you have scheduled for 2:00 a.m., the schedule will not be triggered during daylight saving time (DST).

  7. In the Snapshot settings section, specify the number of snapshots that you want to keep.

  8. In the Retention page, specify the retention settings for the backup type and the schedule type selected in the Backup Type page:

    If you want to…​ Then…​

    Keep a certain number of snapshots

    Select Copies to keep, and then specify the number of snapshots that you want to keep.

    If the number of snapshots exceeds the specified number, the snapshots are deleted with the oldest copies deleted first.
    Important For Snapshot copy-based backups, you must set the retention count to 2 or higher if you plan to enable SnapVault replication. If you set the retention count to 1, the retention operation might fail because the first snapshot is the reference snapshot for the SnapVault relationship until a newer snapshot is replicated to the target.

  9. Review the summary, and then click Finish.