NetBackup™ for MySQL Administrator's Guide
- Introduction to NetBackup for MySQL Agent
- Installing NetBackup for MySQL Agent
- Planning the installation of NetBackup for MySQL Agent
- Verifying the operating systems and the platforms
- Installing prerequisites of NetBackup for MySQL Agent
- Post-installation requirements for NetBackup for MySQL Agent
- Describing the NetBackup for MySQL Agent package
- Installing the NetBackup for MySQL Agent
- Authenticating the password
- Uninstalling the NetBackup for MySQL Agent
- Configuring NetBackup for MySQL Agent
- NetBackup for MySQL backup and restore
- Troubleshooting for NetBackup for MySQL
- Appendix A. The NetBackup for MySQL commands and conventions
- Appendix B. The NetBackup for MySQL commands
- Index
About NetBackup for MySQL Agent
NetBackup for MySQL Agent extends the capabilities of NetBackup to include backup and restore operations of MySQL databases. The agent is located on the NetBackup client and supports the operations on standalone setups. The agent supports MySQL version 5.5.5 and later.
The agent also supports to:
Validate the backup information.
Query backups.
Delete the backup information from the catalog files.
Redirect restore to a client different from that originally performed the backup.
Note:
Ensure that versions of the MySQL agent and NetBackup are same for successful backup and restore operations. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.
The agent reads the parameters from the nbmysql.conf file and then initiates the operations. The nbmysql.conf file includes the parameters that you must set before you run the respective operations.
See The nbmysql configuration file.
The agent communicates with the MySQL database to create a snapshot. The Volume Shadow Copy Services (VSS) for Microsoft Windows or Logical Volume Manager (LVM) for Linux, takes a snapshot of the database.
The agent then interacts with the NetBackup XBSA interface to update the server name, policy, and schedule type information. The NetBackupmaster server connects to the NetBackup client to backup or retrieve the data that you want to protect. The agent mounts the snapshot, copies the file, and sends it to the NetBackup XBSA interface.
The NetBackup XBSA interface writes this data to the mounted media or disk storage managed by the NetBackupmedia server.