Performing MySQL Dump/Exports in AWS Outposts

Updated

Commvault protects MySQL database in AWS Outposts.

You can configure a database server to represent the AWS Outposts. You can back up individual database groups, restore database in-place and out-of-place to a different server.

For more information, see MySQL.

What Gets Backed Up

  • MySQL system databases

  • MySQL user databases

  • MySQL databases (data and logs)

What Does Not Get Backed Up

  • Operating system data

  • MySQL application files

  • MySQL Server information schema

  • MySQL Server performance schema

Considerations

The following Amazon RDS system components are required:

  • A MediaAgent

  • A proxy server that facilitates the backup and restore operations

  • An Amazon RDS virtualization client

For more information, see Amazon RDS System Components.

MySQL Configuration

  • To configure a MySQL server instance that is hosted in the Amazon RDS cloud, create an EC2 instance in the Amazon cloud to function as the proxy client computer, add the proxy client computer in the CommCell Console, create a virtualization client to function as the pseudoclient, and then add the MySQL server instance to the pseudoclient.

    For more information, see Configuration for Amazon RDS for MySQL.

MySQL Backup

  • You can perform a logical data dump backup of the data. When you perform a backup operation, the Commvault software invokes the MySQL mysqldump client utility to perform the backup operation.

    For more information, see Backing Up a MySQL Database.

MySQL Restore

  • You can restore a MySQL server in the Amazon RDS cloud. The destination can be the same instance as the backup or a different instance. You can perform the restore operation from the Amazon RDS virtualization client computer.

    For more information, see Restoring MySQL Instances.