Configuring a MySQL Database Instance to Run Backup Operations on a Standby Server

You can configure an instance to run backup operations from a standby server.

Note

During backups on a MySQL standby server, by default, both data and log backups run. To run a transaction log backup, enable the --log-slave-updates parameter on the standby server.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance for which you want to run backup operations from a standby server.

    The instance page appears.

  3. On the Overview tab, click Edit.

    The Edit MySQL instance dialog box appears.

  4. Move the Use standby instance for backup toggle key to the right, and then select the standby instance that you want to run backup operations on.

  5. Click Save.

Loading...