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 database Overview tab appears.

  2. On the Instances tab, click the instance for which you want to run transaction log backup operations on the source computer.

    The instance Overview page appears.

  3. In the General tile, click Edit.

    The Edit MySQL instance dialog box appears.

  4. Under the Advanced options section, move the Use standby instance for backup toggle to right, and then select a standby instance from the Standby instance list.

  5. Click Update.

Loading...