Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Create a PostgreSQL Flexible Server database instance in DuploCloud
Navigate to Administrator -> Infrastructure from the DuploCloud Portal.
From the NAME column, select the Infrastructure.
Select the Subnets tab, and click Add. The Add Subnet pane displays.
Enter a name for the subnet in the Name field.
Enter the Address Prefix for the subnet.
From the Type list box, select PostgreSQL Flexi Server.
In the Isolated Network list box, select Yes or No.
Select the appropriate endpoints from the Service Endpoints list box.
Click Add. The subnet is added.
From the DuploCloud Portal, navigate to Cloud Services -> Database -> PostgreSQL Flexible.
Click Add. The Create PostgreSQL Flexible Instance page displays.
Complete the required fields.
From the Subnet list box, select the PostgreSQL Flexi Server subnet previously created.
Click Submit. The PostgreSQL Flexible Server database is created.
From the DuploCloud Portal, navigate to Cloud Services -> Databases -> PostgreSQL Flexible, and click on the PostgreSQL Flexible Server database in the NAME column. Use the Overview and Details tabs to view database info.
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.
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.
Create an Azure Managed Instances in DuploCloud
In the DuploCloud Portal, navigate to Cloud Services -> Database -> Managed Instances. The Create Managed SQL Instance pane displays.
Click Add.
Provide the database Name, Username, Password, and vCore. Modify other values as needed.
Click Submit.
You can view Azure Managed Instances and configure other options by selecting the instance you created, from the Managed Instances page in the DuploCloud Portal.
Create a PostgreSQL database instance in DuploCloud
In the DuploCloud Portal, navigate to Cloud Services -> Database -> PostgreSQL.
Click Add. The Create PostgreSQL Instance pane displays.
Provide Name, Database Username, and Password with Service Tier details to create a PostgreSQL database. DuploCloud provides a configuration to support backup retention for your database when you complete the other fields in the pane.
Click Submit.
By selecting your database in DuploCloud from the PostgreSQL page, you can view the created database's Name, Tier, Status, and Version.
You can reboot the database instance and configure Virtual Network and Firewall Rules from the Actions menu.
Create a Redis database in DuploCloud
To create a Redis with public network access, follow the steps below to configure public network access for databases before creating a Redis database instance. If your database does not need to be publicly accessible, skip this step, and proceed to .
In the DuploCloud Portal, navigate to Administrator -> Tenant.
Select the Tenant where the Redis will be created from the NAME column .
Select the Settings tab, and click Add. The Add Tenant Feature pane displays.
From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.
Enable the setting, and click Add. The Allow Public Network Access for Databases and Cache Servers Tenant setting value is True.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> Redis. The Create Redis Instance pane displays.
Click Add.
Provide the database Name.
From the Subnet list box, select an available subnet you have defined in your Infrastructure.
Modify values for Service Tier, Shards, and Non TLS Port, as needed.
Click Submit.
View Alerts by selecting the Redis instance you created, from the Redis page in the DuploCloud Portal.
Databases supported by DuploCloud Azure
A number of databases are supported for DuploCloud and Microsoft Azure. Use the procedures in this section to set them up.
When using Azure Databases, select a Tenant other than the Default Tenant.
Create a Microsoft SQL (MSSQL) Server database in DuploCloud
To create an MSSQL Server database with public access, configure the following Tenant setting to allow public network access for databases and cache servers. If the database does not need public access, skip this step and create an MSSQL Server database.
From the DuploCloud Portal, navigate to Administrator -> Tenants.
Select the Tenant from the NAME column.
Select the Settings tab, and click Add. The Add Tenant Feature pane displays.
From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.
Enable the setting, and click Add. Public database access is enabled.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer, and click Add.
Provide a name for the MSSQL Server database, your username and password, and database version information.
From the Public Access list box, select Enabled or Disabled. If Enabled is not available, complete the steps above under Prerequisites to enable this option.
Click Submit. The MSSQL Server database is created.
A private endpoint is a network interface that connects you privately and securely to your MSSQL Server database. This ensures that the traffic between your virtual network and the MSSQL database travels entirely without using the public internet.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
Select the Private Endpoints tab, and click Add. The Add Private Endpoint pane displays.
Add a name and select a subnet for your private endpoint.
Click Submit. The private endpoint is created and accessible via the selected subnet.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
Select the Databases tab to view the databases and details.
Azure SQL Database Elastic Pools provide cost-effective database resource management by pooling multiple databases together and sharing resources based on their individual needs.
Configure Azure Elastic Pools for an MSSQL Server in the DuploCloud Portal:
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
Select the Elastic Pools tab, and click Add. The Add SQL Elastic Pool pane displays.
Enter a name for the elastic pool, select your service tier, and select the correct SKU.
Click Submit. The elastic pool is created.
Virtual network rules restrict access to your Azure SQL Database server to specific subnets within a virtual network to enhance security and network isolation. Public access must be disabled to add virtual network rules.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
Select the Virtual Network Rules tab, and click Add. The Add New Virtual Network Rule pane displays.
Add a name for the virtual network rule, and select the subnet for your MSSQL database. Click Create. The virtual network rule is created.
Firewall rules for an MSSQL Server help control access to your database server by allowing or denying traffic based on IP addresses. These rules secure your database by restricting access to only trusted sources. Public access must be disabled to add firewall rules.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
Select the Firewall Rules tab, and click Add. The Add New SQL Server Firewall Rule pane displays.
Add a name for the firewall rule, and select the starting and ending IP addresses for your MSSQL database. Click Create. The firewall rule is created.
Create a MySQL Server single server database in DuploCloud
Azure Database for MySQL Single Server has been deprecated. You can no longer create a database with MySQL Single Server. Use to create a new MySQL Single Server instance.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MySQL to view database details, reboot, delete a database, and perform supported actions by selecting the MySQL instance you created, from the Name column on the MySQL page.
