Oracle is the preferred RDBMS solution for line-of-business applications, owing to its proven performance, data integrity, security, and portability features. Deploying Oracle on Azure has become increasingly popular due to the close collaboration and commitment of Oracle and Microsoft to deliver and end-to-end support for Oracle-dependent enterprise applications with Azure database workloads.
There are two primary ways to deploy Oracle on Azure:
Both of these solutions are certified by Oracle to be deployed in Azure, with out-of-the-box lifecycle support from Microsoft. Which is right for you?
This blog will explore both options for deploying Oracle on Azure, delve into the pros and cons and best fit solution for enterprise scenarios, and see how Cloud Volumes ONTAP for Azure can help.
In this article, you will learn:
Depending on the deployment option you choose, your licensing options and migration paths will vary.
Licensing
Oracle is available in various editions, of which the Enterprise and Standard editions are certified by Oracle to be deployed on Azure. Let’s look into some of the key considerations while planning for Oracle deployment in Azure.
Data Migration
The ease with which data can be migrated to the cloud plays an important role in the success of any digital transformation program.
One popular option to deploy an Oracle database on Azure is to use the database-as-a-service (DBaaS) model. In a DBaaS, the platform-level configuration and management are done by Azure and the customer owns the database specific configuration.
Unlike other DB platforms such as MSSQL and MySQL, Oracle does not have its own DBaaS offering in Azure at the time of this writing. Instead, Microsoft in collaboration with Oracle offers integration of Azure infrastructure with Oracle Cloud Infrastructure (OCI) so that Oracle applications deployed in Azure can seamlessly connect to backend databases.
To ensure high performance, you need a high-bandwidth, secure connection between the OCI database layer and the Oracle application layer in Azure. You can achieve this using Azure ExpressRoute and Oracle FastConnect. The prerequisite for this configuration is that the peering location of both the services should be in proximity to each other - this is supported in only a few Azure regions.
Many popular Oracle application stacks including E-Business suite, PeopleSoft, Oracle Retail applications and more are certified by Oracle to be deployed using this OCI interconnect model.
Oracle Autonomous Database service on OCI
Oracle Autonomous Database is a managed service offering from Oracle Cloud Infrastructure that can be integrated with your Oracle applications deployed in Azure. Autonomous Database supports transaction processing and data warehousing workloads.
Oracle Autonomous Database supports Oracle database 18c and 19c; however, note these two versions are not available in all regions.
Autonomous Database in OCI makes it possible to automate the creation of full backups on a weekly basis, followed by daily incremental backups. However, the retention period of those backups is limited to 60 days. If the automated backup schedule does not meet your organizational requirements, you might need to trigger backups manually or using the OCI SDK, initiating the backup programmatically with REST API calls.
Since OCI supports only the latest version of Oracle, organizations with dependency on legacy versions would have to make additional investments to either upgrade their database or modernize their applications to suit the available database version.
For customers who want full control of the deployment stack, starting from OS and up to the application layer, Azure supports deployment of Oracle in an infrastructure-as-a-service (IaaS) model.
This deployment model uses Oracle Linux images in the Azure Marketplace. Customers can also choose to bring their own image to Azure or deploy the database independently in a non-Oracle Linux image, also available in the Marketplace.
Azure also supports popular Oracle applications such as Oracle WebLogic as readily available Marketplace images integrated with the Azure Application Gateway and Azure Active Directory.
The IaaS deployment model that uses Azure compute and storage services offer more flexibility, compared to the managed service OCI option.
However, it should be noted that compared to a DBaaS solution, there are additional responsibilities to be addressed here: factors like high availability, backup, patching, upgrades, and failovers, especially in production deployments.
Managing storage for your Oracle database
Customers can leverage the custom-built Azure VM SKUs and employ additional managed storage services tuned for IOPS intensive database operations in Azure.
The IOPS available for Oracle databases can be greatly improved by distributing the data across multiple disks managed by Oracle Automated Storage Management (ASM). The collective IOPS from the disks deliver much improved storage performance and faster database transactions. Choosing the right storage management solution makes a world of difference here.
Azure managed disks, a managed storage service from Azure, offers different performance options such as Premium and Ultra disks, which can be used to handle storage for your Oracle database.
While the managed service offering using OCI eases the infrastructure deployment requirements, there are many additional challenges associated with them: restricted versioning, regional availability, and integration complexity.
Deployment in the IaaS model can help ease up these concerns, as this model provides end-to-end flexibility for the deployment with any Oracle database version in any Azure region. However, it introduces complexity in managing storage and associated issues like high availability and disaster recovery.
NetApp Cloud Volumes ONTAP augments the native Azure cloud storage layer, delivering an enterprise-class data management solution, with the simplicity of a managed service. It provides:
An Oracle with Managed Storage Case Study
A major online fashion retailer with headquarters in the United Kingdom chose to deploy an Oracle database in a self-managed option on an Azure VM.
The company offers a selection of hundreds of brands as well as its own line of clothing and accessories and ships to countries worldwide. This company’s entire retail stack is based on Oracle, meaning Oracle is extremely mission critical.
By deploying their database on an Azure VM and managing storage with Cloud Volumes ONTAP, this company was able to ensure the database has high availability across regions to ensure their business continuity, without the restrictions of the OCI managed service.
Here are several more advantages of managing storage for an Oracle database using Cloud Volumes ONTAP: