MySQL Flexible Server
Create a MySQL Flexible Server database service in DuploCloud
Last updated
Was this helpful?
Create a MySQL Flexible Server database service in DuploCloud
Last updated
Was this helpful?
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.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MySQL Flexible.
Click Add. The MySQL Flexible page displays.
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.
Click Submit.
You cannot change the value of the High Availability field, once the MySQL Flexible Server is created.
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.
In the DuploCloud Portal, navigate to Administrator -> System Settings.
Select the System Config tab.
Click Add. The Add Config pane displays.
From the Config Type list box, select AppConfig.
From the Key list box, select "AZURE_DEFAULT_MYSQL_GEO_REDUNDANT_BACKUP_ENABLED".
In the Value field, enter "True". Click Submit. Redundant backup is enabled.
In the DuploCloud Portal, navigate to Administrator -> System Settings.
Select the System Config tab.
Click Add. The Add Config pane displays.
From the Config Type list box, select AppConfig.
From the Key list box, select "AZURE_DEFAULT_MYSQL_BACKUP_RETENTION_DAYS".
In the Value field, enter the number of days to retain the backup, from one (1) to thirty-five (35).
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.
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.
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.
