As a database administrator (DBA), you support your company’s most business-critical applications—databases—and you are accountable for ensuring their availability. Because of the mission-critical nature of your job, you want complete control over the access, security, data integrity and resiliency of the databases you manage.
NetBackup for Backup and Recovery of MySQL/PostgreSQL Databases
With the introduction of Veritas NetBackup 10.1, MySQL and PostgreSQL database administrators (DBA), can now setup backups for new instances or databases and manage daily data protection without needing full NetBackup console access. The MySQL and PostgreSQL DBA can now perform the following:
Recovery of MySQL/PostGresQL Instance
To begin the recovery of a MySQL or PostgreSQL database instance, navigate to either MySQL or PostgeSQL located under Workloads in the NetBackup WebUI.
Note: MySQL was used for the following restore, but the steps are the same for PostgreSQL.
Figure 1: Perform a MySQL/PostgreSQL Instance Restore.
Select the Recovery Points tab and select the instance backup you’d like to restore.
Figure 2: Select backup image.
The next step is to enter the recovery target and choose whether to restore to the original or an alternate location.
Figure 3: Select where to restore the backup.
Review the summary of the restore, and when everything looks good begin the recovery.
Figure 4: Ready to start the recovery.
Veritas NetBackup now makes it easier for MySQL and PostgreSQL DBAs giving them the ability to setup backups for new instances or databases and manage daily data protection without needing full NetBackup console access. Veritas NetBackup makes back and recovery for MySQL and PostgreSQL instances and databases simple and flexible.