MySQL Flexible Server

Create a MySQL Flexible Server database service in DuploCloud

Use a Microsoft Azure MySQL Flexible Server managed database service in DuploCloud. Flexible Server is designed for more granular control and flexibility over database management functions and configuration settings and allows users access to High Availability (HA) in both single availability zones and across multiple availability zones. Flexible servers provide better cost optimization and are ideal for workloads that don’t need continuous full-compute capacity.

Creating a MySQL Flexible Server

  1. In the DuploCloud Portal, navigate to DevOps -> Database -> MySQL Flexible.

  2. Click Add. The MySQL FLexible page displays.

  3. Provide the database Name, User Name, Service Tier, Password, Database Version, and other required fields. As you complete the fields on the page, additional fields display, such as High Availability, if applicable.

  4. Click Submit.

You cannot change the value of the High Availability field, once the MySQL Flexible Server is created.

Setting up Database Backup

Setup Database Backup and choose the number of days (1-35) to backup databases in the DuploCloud Portal System Settings. First, enable Redundant Backup, and then set the Backup Retention Period.

Enabling Redundant Backup

  1. In the DuploCloud Portal, navigate to Administrator -> System Settings.

  2. Select the System Config tab.

  3. Click Add. The Add Config pane displays.

  4. From the Config Type list box, select AppConfig.

  5. From the Key list box, select "AZURE_DEFAULT_MYSQL_GEO_REDUNDANT_BACKUP_ENABLED".

  6. In the Value field, enter "True". Click Submit. Redundant backup is enabled.

Set the Backup Retention Period

  1. In the DuploCloud Portal, navigate to Administrator -> System Settings.

  2. Select the System Config tab.

  3. Click Add. The Add Config pane displays.

  4. From the Config Type list box, select AppConfig.

  5. From the Key list box, select "AZURE_DEFAULT_MYSQL_BACKUP_RETENTION_DAYS".

  6. In the Value field, enter the number of days to retain the backup, from one (1) to thirty-five (35).

  7. Click Submit. Backup retention is configured for the selected number of days.

Once set, the Backup Retention Period will apply to all new databases. When creating a new database, you can override this by entering a value into the Backup Retention field on the Create MySQL Flexible Instance page.

Viewing a MySQL Flexible Server

You can view details and configure other options by selecting the MySQL Flexible Server you created, from the MySQL Flexible page in the DuploCloud Portal.

Additional supported actions

From the MySQL Flexible page, you can click the Actions menu for each Flexible Server and select the appropriate option to enter the Azure Portal, Reboot the server, or Stop the server.

Last updated

Logo

© DuploCloud, Inc. All rights reserved. DuploCloud trademarks used herein are registered trademarks of DuploCloud and affiliates