Provision and manage Azure CosmosDB accounts and databases in DuploCloud
Azure CosmosDB is a globally distributed, multi-model NoSQL database service designed for high availability, low latency, and seamless scalability. It supports various data models such as key-value, document, graph, and column-family, making it ideal for modern cloud-native applications.
In DuploCloud, you can provision and manage Azure CosmosDB accounts, which serve as top-level containers for your databases. Each account defines key configurations like capacity mode, public access, and authentication. Once an account is created, you can add multiple databases within it to organize and store your application data.
This page describes how to provision and manage Azure CosmosDB accounts and resources in the DuploCloud Portal.
Adding an Azure CosmosDB Account
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Click Add. The Create CosmosDB Account pane displays.
Complete the following fields:
Click Submit to create the account. Once created, the CosmosDB account appears in the list and can be managed or referenced in your infrastructure deployments.
Viewing a CosmosDB Account
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Click on the name of the CosmosDB account in the NAME column.
Select the Databases, Private Endpoints, or Details tab to view account details.
Managing a CosmosDB Account
After creating a CosmosDB account in DuploCloud, you can view, edit, or delete the account:
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Click the menu icon () in the row of the CosmosDB account you want to manage.
Choose from the following options:
Adding a Database in Data Explorer
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Select the CosmosDB account from the NAME column.
Select the Data Explorer tab.
Adding a Private Endpoint
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Select the CosmosDB account from the NAME column.
Select the Private Endpoints tab.
JSON: View the raw JSON configuration of the CosmosDB account.
Edit: Modify the account settings.
Delete: Permanently remove the CosmosDB account.
Click Add. The Add CosmosDB Database pane displays.
Enter a Name for the database.
Click Create to add the database.
Click Add. The Add Private Endpoint pane displays.
Provide a Name for the endpoint
Select the Subnet where the endpoint will be created
Click Create to establish the private endpoint.
Name
Enter a friendly name for the CosmosDB account.
Capacity Mode
Choose either Provisioned throughput or Serverless.
Public Access
Select whether public network access is Enabled or Disabled.
Enable Free Tier
Enable Azure’s free-tier capacity, if needed.
Key-based Authentication
Enable key-based access credentials for CosmosDB, if needed.
Create CosmosDB Account pane
CosmosDB page with the menu options highlighted
Details tab for the cosmodb-1243 CosmosDB account
Details tab for the cosmodb-1243 Cosmosdb account
Add CosmosDB Database pane
Add Private Endpoint pane
Microsoft SQL Server (MSSQL)
Create a Microsoft SQL (MSSQL) Server database in DuploCloud
DuploCloud supports the deployment and management of Microsoft SQL Server (MSSQL) on Azure. You can use the DuploCloud Portal to create MSSQL Servers, add databases, and apply network and security configurations such as firewall rules, private endpoints, and virtual network rules.
Prerequisites
Enable public access for MSSQL Servers
To create an MSSQL Server with public access, you must first enable a Tenant setting that allows public network access for databases and cache servers. If public access is not required, you can skip this step and proceed directly to .
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.
Creating an MSSQL Server
Create a new Microsoft SQL Server instance in your tenant to host one or more SQL databases for your applications.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Click Add. The Add SQL Server pane displays.
Adding an SQL database
After creating an MSSQL Server, you must add one or more SQL databases to store your application data.
Select the Tenant from the Tenant list box.
Navigate to Cloud Services → Database → MSSQL Server.
Select the MSSQL Server from the NAME column.
Click Submit to create the database.
Updating the backup retention period for a database
The default backup retention period for an SQL database is 7 days. You can update this setting to retain backups for up to 35 days.
Select the Tenant from the Tenant list box.
Navigate to Cloud Services → Database → MSSQLServer.
Select the MSSQL Server from the NAME column.
Enter a value between 1 and 35 days and click Save.
The backup retention period cannot be configured for the master database.
Viewing MSSQL Server and database details
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services → Database → MSSQLServer.
Select the MSSQL Server from the NAME column. The MSSQL Server details page displays.
Use the tabs to view server details:
You can also use the Actions button at the top right of the page:
To manage an individual database, go to the Databases tab and click the menu icon () next to the database name:
The master database is managed by Azure and cannot be edited or deleted.
Adding private endpoints
A private endpoint is a network interface that connects you privately and securely to your MSSQL Server. 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.
Configuring elastic pools
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.
Setting virtual network rules
Virtual network rules restrict access to your MSSQL Server to specific subnets within a virtual network, enhancing security and network isolation. Public access must be enabled to add virtual network rules.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.
Select the MSSQL Server from the NAME column.
Setting firewall rules
Firewall rules for an MSSQL Server control access by allowing or denying traffic based on IP addresses. These rules help secure your databases by restricting access to trusted sources. Public access must be enabled to add firewall rules.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.
Select the MSSQL Server database from the NAME column.
PostgreSQL Flexible Server
Create a PostgreSQL Flexible Server database instance in DuploCloud
Prerequisites
Create a PostgreSQL Flexible Server subnet in the Infrastructure
Databases
Databases supported by DuploCloud Azure
DuploCloud supports the following databases for Microsoft Azure. Use the procedures in this section to set them up.
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 Azure CLI to create a new MySQL Single Server instance.
Viewing database details
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.
From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.
Enable the setting, and click Add. Public access is enabled.
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.
In the Databases tab, click Add. The Create SQL Database pane displays.
Create SQL Database pane
Complete the following fields:
Select the Databases tab.
Click the menu icon () next to the database and select Update Short Term Retention. The Update Backup Retention Period pane displays.
Use one of the following options to manage the server and its databases:
Select the Private Endpoints tab, and click Add. The Add Private Endpoint pane displays.
The Add Private Endpoint pane
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 Elastic Pools tab, and click Add. The Add SQL Elastic Pool pane displays.
The Add SQL Elastic Pool pane
Enter a name for the elastic pool and configure the SQL Elastic Pool (select your Service Tier, Sku Name, Max Storage Size).
Click Submit. The elastic pool is created.
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. Click Create. The virtual network rule is created.
Select the Firewall Rules tab, and click Add. The Add New SQL Server Firewall Rule pane displays.
Add New SQL Server Firewall Rule pane
Add a name for the firewall rule, and specify the starting and ending IP addresses that should be allowed to access your MSSQL database.
Click Create. The firewall rule is added to the server.
Firewall Rule tab on the MSSQL Server page.
Name
Enter a name for the database.
Use Elastic Pool
Select whether to use an elastic pool. Default is No.
Service Tier
Select the service tier.
SKU Name
Select the SKU name.
Collation
Optionally, enter the collation setting.
Databases
View or manage the databases associated with this server.
Elastic Pools
View or configure elastic pool settings, if applicable.
Private Endpoints
View or manage private network connections.
Virtual Network Rules
View or manage subnet-based access restrictions. This tab is only visible when public access is enabled.
Firewall Rules
View or manage IP-based firewall rules. This tab is only visible when public access is enabled.
Azure Portal
Open the server directly in the Azure Portal.
Delete SQL Server
Delete the server if no databases remain.
Edit
Update the database name or settings.
Update Short Term Retention
Configure the backup retention period for the database.
Virtual Network Rule tab on the MSSQL Server page.
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.
The Add Subnet pane in the DuploCloud Portal
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.
Creating a PostgreSQL Flexible Server database
From the DuploCloud Portal, navigate to Cloud Services -> Database -> PostgreSQL Flexible.
Click Add. The Create PostgreSQL Flexible Instance page displays.
The Create PostgreSQL Flexible Instance page
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.
Viewing a PostgreSQL Flexible Server database
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.
Redis database
Create a Redis database in DuploCloud
Prerequisites
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 creating a Redis database instance.
Configure public network access for databases (optional)
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.
Creating a Redis database instance
In the DuploCloud Portal, navigate to Cloud Services -> Database -> Redis.The Create Redis Instance pane displays.
Click Add.
Provide the database Name.
Viewing Database details
View Alerts by selecting the Redis instance you created, from the Redis page in the DuploCloud Portal.
PostgreSQL database
Create a PostgreSQL database instance in DuploCloud
Creating a Postgre database instance
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.
Viewing database details
By selecting your database in DuploCloud from the PostgreSQL page, you can view the created database's Name, Tier, Status, and Version.
Additional supported actions
You can reboot the database instance and configure Virtual Network and Firewall Rules from the Actions menu.
Azure Managed SQL Instances
Create an Azure Managed SQL Instances in DuploCloud
An offers a fully managed, scalable SQL database service. It simplifies database management by handling tasks like backups, patching, and scaling, so you can focus on your applications without worrying about infrastructure.
Creating an Azure Managed SQL Instance
Complete the steps to create an Azure Managed SQL Instance in the DuploCloud Portal:
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.
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.
Create Redis Instance pane
Redis page in DuploCloud Portal
Alerts tab for Redis database instance
Create PostgreSQL Instance pane
In the DuploCloud Portal, navigate to Cloud Services -> Database -> Managed Instances.
Click Add. The Create Managed SQL Instance pane displays.
The Create Managed SQL Instance pane
Complete the fields:
Name
Enter a name for the Managed SQL Instance
Username
Create a username for the Managed SQL Instance
Password
Create a password for the Managed SQL Instance
Service Tier
Select your service tier (General Purpose or Business Critical)
Hardware
Select the hardware generation for the instance, such as Gen5
vCore
Select the number of virtual cores allocated to the instance
Storage(GB)
Select the amount of storage in gigabytes for the managed instance (e.g., 32 GB)
Click Submit to generate the Managed SQL Instance.
Additional Managed SQL Instance Options
Navigate directly to the Azure Portal to manage and configure a Managed SQL instance or delete a Managed SQL Instance from within the DuploCloud Portal:
In the DuploCloud Portal, navigate to Cloud Services -> Database -> Managed Instances.
Click the menu icon () in the row of the Manages SQL Instance.
Select from the following options:
Azure Portal
Navigate to the Azure portal to manage and configure your Managed SQL instance
Delete
Delete the Managed SQL Instance
The Managed Instances page in the DuploCloud Portal
Specify the subnet where the managed instance will be deployed
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
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.
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.
Enable Redundant Backup
In theDuploCloud Portal, navigate to Administrator -> System Settings.
Select the System Config tab.
Click Add. The Add Config pane displays.
Set the Backup Retention Period
In theDuploCloud Portal, navigate to Administrator -> System Settings.
Select the System Config tab.
Click Add. The Add Config pane displays.
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.
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.
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.
MySQL Flexible page
The Add Config pane filled to enable Azure Default Redundant Backup.
The Add Config pane configured to retain backups for 35 days.
Systems Settings with System Config tab selected
MySQL Flexible page with Overview tab displayed
MySQL Flexible page with Actions menu expanded, displaying options for the MY-INSTANCE Flexible Server
