Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Databases supported by DuploCloud Azure
DuploCloud supports the following databases for Microsoft Azure. Use the procedures in this section to set them up.
SQL Database (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.
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.
From the
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 -> MSSQL Server.
Click Add. The Add SQL Server pane displays.
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.
In the Databases tab, click Add
Click Submit to create the 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.
Select the Databases tab.
Enter a value between 1 and 35 days and click Save.
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:
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.
Select the Private Endpoints
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
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.
Select the Virtual Network 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.
Select the Firewall Rules
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.
In the DuploCloud Portal, navigate to Administrator -> System Settings.
Select the System Config tab.
Click Add. The Add Config pane displays.
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.
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 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.
Enable the setting, and click Add. Public access is enabled.
Provide a name for the MSSQL Server, 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 is created.
Complete the following fields:
Click the menu icon () next to the database and select Update Short Term Retention. The Update Backup Retention Period 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.
Enter a name for the elastic pool, select your service tier, and select the correct SKU.
Click Submit. The elastic pool is created.
Add a name for the virtual network rule, and select the subnet. Click Create. The virtual network rule is created.
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.
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.
Delete
Remove the database from the server.
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.
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.
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.
Complete the steps to create an Azure Managed SQL Instance in the DuploCloud Portal:
Create a Redis database in DuploCloud
Click Add. The Create Managed SQL Instance pane displays.
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.
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
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.
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.
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.
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.
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.
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.
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:
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Select the CosmosDB account from the NAME column.
Select the Data Explorer tab.
Click Add. The Add CosmosDB Database
In the DuploCloud Portal, navigate to Cloud Services → Databases → CosmosDB.
Select the CosmosDB account from the NAME column.
Select the Private Endpoints tab.
Click Add. The Add Private Endpoint
Subnet
Specify the subnet where the managed instance will be deployed
JSON: View the raw JSON configuration of the CosmosDB account.
Edit: Modify the account settings.
Delete: Permanently remove the CosmosDB account.
Enter a Name for the database.
Click Create to add the database.
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.
cosmodb-1243 CosmosDB accountcosmodb-1243 Cosmosdb account
