NetWorker: Configure MySQL/MariaDB with NMDA Using Orchestrated Application Protection (OAPP)

Prerequisites

• Download NMDA and required NetWorker packages from the Dell web portal:
  • NetWorker Client
  • NetWorker Extended Client
  • NMDA
• Install packages on the client using the OS command line.
• Install DD BoostFS for OAPP functionality.

Download DD BoostFS.

1. Navigate to:
   Dell Support Home Page
2. Enter 'Data Domain Boost - File System' in the 'Identify your Product' Search box.
3. Select 'Drivers & Downloads' from the menu panel on the left
4. Select the required DD BoostFS version and click 'Download'
5. The EULA is displayed in PDF format, scroll to the bottom, and click 'I accept'.
6. From the second PDF, select the appropriate installer for your OS: For example,
   • DD BoostFS 7.10.1.70 Code:
     • AMD: DDBoostFS_7.10.1.70-1178590_amd64.deb
RHEL: DDBoostFS-7.10.1.70-1178590.rhel.x86_64.rpm
SLES: DDBoostFS-7.10.1.70-1178590.sles.x86_64.rpm
WINDOWS: BoostFSInstaller-7.10.1.70-1178590.msi
     • PGP Keys and SHA256 checksums are provided for verification.

NMDA Installation

Follow the NMDA Installation Guide for your version.

OAPP Configuration

Switch to the NMDA 19.1 Administration Guide:

• OAPP section starts on page 66 - Search 'Orchestrated Application' to find relevant content within the Guide.
• Search the guide for 'NMDA MySQL parameters' for details on variable settings.

Note: OAPP clients do not support the wizard-based configuration. Create the client resource manually.

Required Information

• OS user running MariaDB/MySQL (default: mysql)
• Database user with backup privileges (default: root)
• NetWorker server name
• NetWorker client name
• Target NetWorker pool (full and incremental backups can share the same pool)

NetWorker Client Configuration

• Create the client definition manually.
• Saveset: OAPP
• Backup command:
  nsroappbackup -z <path to .cfg file>
• Complete other fields as per standard client configuration.

MySQL/MariaDB Specific Steps

• No changes to my.cnf unless custom variables are required.
• Default MariaDB paths:
  • Config: /opt/lampp/etc/my.cnf
  • Backup tool: /opt/lampp/bin/mariabackup

Backup Scripts

Full Backup Script:

• #!/bin/sh
  # Full backup of MySQL/MariaDB instance
  mariabackup --backup --user=<username> --password=<password> --target-dir=$OAPP_MOUNT_DIR
  

  Incremental Backup Script:

• #!/bin/sh
  # Incremental backup of MySQL/MariaDB instance
  mariabackup --backup --incremental --user=<username> --password=<password> --target-dir=$OAPP_MOUNT_DI
  

Security Notes:

• Avoid storing plain-text passwords in scripts:
  • Use USER_PSWD_PROMPT in the .cfg file.
  • Encrypt the password using:
    nsrdaadmin -P -z <path to .cfg file>
• Place scripts and .cfg files under /nsr/apps/config (or customer-defined location).
• Set permissions to 700 and ensure ownership by NSR_OS_USER.

Configuration File Example:

• <?xml version="1.0" encoding="UTF-8"?>
  <OAPP>
      <NSR_SERVER>{NetWorker server}</NSR_SERVER>
      <NSR_CLIENT>{Client name}</NSR_CLIENT>
      <NSR_DATA_VOLUME_POOL>{Pool name}</NSR_DATA_VOLUME_POOL>
      <NSR_BACKUP_NAME>{Backup reference}</NSR_BACKUP_NAME>
      <NSR_DATABASE_TYPE>Mysql_MariaDB</NSR_DATABASE_TYPE>
      <NSR_INSTANCE_NAME>{Instance name}</NSR_INSTANCE_NAME>
      <NSR_BACKUP_LEVEL>full</NSR_BACKUP_LEVEL>
      <NSR_OS_USER>mysql</NSR_OS_USER>
      <BACKUP>
          <FULL>
              <NSR_BACKUP_SCRIPT>/{path to full_backup.sh}</NSR_BACKUP_SCRIPT>
          </FULL>
      </BACKUP>
  </OAPP>