Loading...

Advanced Backup – MySQL iDataAgent

Table of Contents

Full Backups

Full backups provide the most comprehensive protection of data.

Backups for any client start with a full backup. The full backup becomes a baseline to which subsequent backup types are applied. For example, a full backup must be performed before a transaction log backup can be initiated.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  2. Right-click an <Subclient>, and then click Backup.
  3. In the Backup Options for Subclient dialog box, select Full as the backup type.
  4. In the Job Initiation area, select Immediate to run the backup right now.
  5. Click OK.

    You can track the progress of the job from the Job Controller.

    When the backup is complete, the Job Controller displays Completed.

Incremental Backups

An incremental backup captures the transaction log that contains a record of all committed or uncommitted transactions. Incremental backups are consistent with the start time of the backup.

Incremental backups make point-in-time recovery possible. This is useful in the case of a database failure where it is unacceptable to lose any data, and you want to restore to the point of failure. If you use only full backups, you can restore to the time of the backup, but not to a point-in-time between backups.

A MySQL incremental backup is similar to a traditional incremental backup that you might perform on a file system because the incremental backup contains only the new changes since the full or another incremental backup.

Each time a transaction log is backed up, it is truncated to the exact time of the backup. No checkpoint is issued at this time; therefore, dirty pages are not written to disk before or after an incremental backup. If there are dirty pages (pages that are changed and not yet added to the database files), any completed transactions must be rolled forward if a transaction log restore is performed. Any transactions not completed at the time an incremental backup is performed are rolled back during a restore involving an incremental backup.

Note: In case of row-based logging, statement-based logging, and mixed logging, follow specific syntaxes to insert statements in the logs. For more information on the syntaxes, see What are the syntaxes to insert statement in case of row-based logging, statement-based logging, and mixed logging?

Before you run incremental backups, make sure that you do the following:

  • Enable binary logging on the MySQL Server.
  • Set the MySQL Server system variable expire_log_days to 0 to make sure that the logs are not pruned by the MySQL Server automatically.
  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  2. Right-click a <Subclient>, and then click Backup.
  3. In the Backup Options for Subclient dialog box, select Incremental as the backup type.
  4. In the Job Initiation area, select Immediate to run the job now.
  5. Click OK.

    You can track the progress of the job from the Job Controller.  When the backup is complete, the Job Controller displays Completed.

Back Up Transaction Log of a Damaged Database (Do Not Truncate Logs)

By default, a full backup truncates and shrinks transaction logs automatically to save space. This might not be acceptable if you experience a database failure and you want to restore to the point of failure. In this case, you must capture all of the transaction log events that have occurred since the last backup was run.

This operation retains the active transaction log.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  2. Right-click a <Subclient>, and then click Backup.
  3. In the Backup Options for Subclient dialog box, select Incremental as the backup type.
  4. Select Do Not Truncate Log.
  5. When this option is selected, the transaction logs before the full or log only backup are not purged from the MySQL Server instance.

  6. In the Job Initiation area, select Immediate to run the job now.
  7. Click OK.

    You can track the progress of the job from the Job Controller.  When the backup is complete, the Job Controller displays Completed.

Scheduling a Backup

  1. From the CommCell Browser navigate to Client Computers | <Client> | MySQL | <Instance>.
  2. Right-click a <Subclient>, and then click Backup.
  3. In Select Backup Type area of the dialog box that appears, select appropriate backup type.
  4. Select Schedule, and then click Configure to set the schedule for the backup job.

    The Schedule Details dialog appears.

  5. Select the appropriate scheduling options.  For example:
    • Click Weekly.
    • Check the days you want the run the backup job.
    • Change the Start Time to 9:00 PM.
    • Click OK to close the Schedule Details dialog box.
    • Click OK to close the Backup Options dialog box.

    The backup job runs according to the schedule that you define.

Managing Jobs

Jobs can be managed in a number of ways. The following sections provide information on the different job management options available:

Restarting Jobs

Jobs that fail to complete successfully are automatically restarted based on the job restartability configuration set in the Control Panel. This configuration can be changed at any time; however, changes to this configuration will affect all jobs run in the entire CommCell.

It is also possible to override the default CommServe configuration for individual jobs by configuring retry settings when initiating the job. This configuration, however, will apply only to the specific job.

Backup jobs for this Agent are resumed from the point-of-failure.

Configure Job Restartability at the CommServe Level

  1. In the CommCell Console, click the Control Panel icon, then double-click Job Management.
  2. In the Job Restarts tab of the Job Management dialog box, select a job type from the Job Type list, and then select the Restartable check box.
  3. To change the maximum number of times the Job Manager will try to restart a job, select a number in the Max Restarts box.
  4. To change the time interval between attempts by the Job Manager to restart the job, select a number of minutes in the Restart Interval (Mins) box.
  5. Click OK to save your changes.

Configure Job Restartability for an Individual Job

  1. From the Archive Options dialog box, click Advanced, then select the Job Retry tab and specify the following as desired:
    • Total Running Time - The maximum elapsed time, in hours and minutes, from the time that the job is created.
    • Number of Retries - The number of times that Job Manager will attempt to restart the job.
    • Kill Running Jobs When Total Running Time Expires - Option to kill the job when the specified Total Running Time has elapsed, even if its state is "Running".
  2. Click OK.

Controlling Jobs

The following controls are available for running jobs in the Job Controller window:

Suspend

Temporarily stops a job. A suspended job is not terminated; it can be restarted at a later time. Only pre-emptible jobs can be suspended.

Resume

Resumes a job and returns the status to Waiting, Pending, Queued, or Running depending on the availability of resources or the state of the operation windows and activity control settings.

Backup jobs for this Agent are resumed from the point-of-failure.

Kill

Terminates a job.

These controls can be applied to:

  • All jobs in the Job Controller.
  • All selected jobs in the Job Controller providing you have the correct security associations at the proper level for each job selected.
  • All data protection operations running for a particular client or client/agent.
  • All data protection operations running for a particular MediaAgent.

From the Job Controller of the CommCell Console, right-click the job and select Kill, Suspend, or Resume as desired.

  • When killing a job:

    Click Yes when the confirmation prompt appears if you are sure you want to kill the job. The job status may change to Kill Pending for a few moments while the operation completes. Once completed, the job status will change to Killed and it will be removed from the Job Controller window after five minutes.

  • When suspending a job:

    The job status may change to Suspend Pending for a few moments while the operation completes. The job status then changes to Suspended.

  • When resuming a job:

    As the Job Manager attempts to restart the job, the job status changes to Waiting, Pending, or Running.

Additional Options

The following table describes the available additional options to further refine your backup operations:

Option Description Related Topics
Startup Options

The Startup Options are used by the Job Manager to set priority for resource allocation. This is useful to give higher priority to certain jobs. You can set the priority as follows:

  1. From the CommCell Browser, navigate to Client Computers | client | MySQL | instance.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and click Startup tab.
  3. Select the Change Priority checkbox.
  4. Enter a priority number - 0 is the highest priority and 999 is the lowest priority.
  5. Select the Start up in suspended State check box to start the job in a suspended state.
  6. Click OK.
Refer to Job Priority and Priority Precedence.
Alerts

This option enables users or user groups to get automatic notification on the status of the data protection job. Follow the steps given below to set up the criteria to raise notifications/alerts:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Alert tab.
  3. Click Add Alert.
  4. From the Add Alert Wizard dialog box, select the required threshold and notification criteria and click Next.
  5. Select the required notification types and click Next.
  6. Select the recipients and click Next.
  7. Click Finish.
  8. Click OK.
Refer to Alerts and Notifications.
CommCell Readiness Report The CommCell Readiness Report provides you with vital information such as connectivity and readiness of the Client, MediaAgent, and CommServe. It is useful to run this report before performing a backup or a recovery operation. Follow the steps given below to generate the report:
  1. On the CommCell Console menu bar, select the Reports tab.
  2. Click Readiness.

    The Report Selection dialog box appears.

  3. If necessary, select Reports | CommServe | CommCell Readiness in the left pane.
  4. Select the Computers tab, and then click Modify below the Computers list.
  5. In the dialog box that appears, clear Include All Client Computers and All Client Groups.
  6. Select the appropriate client from the Exclude list, and then click Include >.
  7. Click OK.
  8. Select the MediaAgent tab, and then clear Include All MediaAgents.
  9. Select the appropriate MediaAgent from the Exclude list, and then click Include >.
  10. Click Run.

    The report appears in your default Web browser.

Refer to CommCell Readiness Report.
Backup Job Summary Report The Backup Job Summary Report provides you with information about all of the backup jobs that are run in last 24 hours for a specific subclient. You can get information such as status, time, data size, and so on for each backup job. It is useful to run this report after performing the backup. Follow the steps given below to generate the report:
  1. On the CommCell Console menu bar, select the Reports tab.
  2. Click Summary.

    The Report Selection dialog box appears.

  3. If necessary, select Reports | Jobs | Job Summary in the left pane.
  4. On the General tab, select Data Management.
  5. Select the Computers tab.
  6. Select Subclient, and then select the Edit sub tab.
  7. Navigate to Client Computers | <Client> | File System | Backup Set | <Subclient>.
  8. Click Run.

    The report appears in your default Web browser.

Refer to Backup Job Summary Report.
Data Path Options

Data Protection operations use a default Library, MediaAgent, Drive Pool, and Drive as the Data Path. You can use this option to change the data path if the default data path is not available. Follow the steps given below to change the default data path:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Data Path tab.
  3. Select the MediaAgent and Library.
  4. Select the Drive Pool and Drive for tape library.
  5. Click OK.
Refer Change Data Path.
Start New Media

The Start New Media option enables you to start the data protection operation on a new media. This feature provides control over where the data physically resides. Use the following steps to start the data protection operation on a new media:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select the Start New Media check box.
  4. Click OK.
Refer to Start New Media.
Mark Media Full on Success

This option marks the media as full, two minutes after the successful completion of the data protection job. This option prevents another job from writing to this media. Follow the steps given below:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select Media tab.
  3. Select the Mark Media Full on Success check box.
  4. Click OK.
Refer to Export Media.
Allow Other Schedules To Use Media Set

The Allow Other Schedules to use Media Set option allows jobs that are part of the schedule or schedule policy and using the specific storage policy to start a new media. It also prevents other jobs from writing to the same set of media.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select the Allow Other Schedules To Use Media Set check box.
  4. Click OK.
Refer to Creating an Exportable Media Set.
Extended Data Retention

This option allows you to extend the expiration date of a specific job. This will override the default retention set at the corresponding storage policy copy. Follow the steps given below to extend the expiration date:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select one of the following options:
    • Infinite - Select this option to extend the expiration date by infinite number of days
    • Number of day - Select this option to specify the number of days to extend the expiration date and then enter the number of days.
  4. Click OK.
Refer to Extended Retention Rules.
Vault Tracker

This feature provides the facility to manage media that is removed from a library and stored in offsite locations. Depending on your Vault Tracker setup, select the required options. Use the following steps to access and select the Vault Tracker options.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Vault Tracking tab.
  3. Select the required options.
  4. Click OK.
Refer to Vault Tracker  or  Vault Tracker Enterprise.