kantver - Fotolia
When should we run Oracle on EC2 vs. RDS?
There are different approaches to running Oracle Database on AWS. What are the strengths and limitations of using Amazon RDS and EC2 for Oracle Database?
Oracle's support for running enterprise applications in the cloud reflects a growing realization that public cloud...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
is a viable and worthwhile alternative to local data center ownership and management. But running complex applications in the cloud can be challenging -- even for experienced IT staff. AWS applications need regular testing and performance monitoring to ensure that mission-critical workloads like Oracle Database will provide the availability and user experience a business is accustomed to and demands.
Oracle Database can run within a suitable EC2 instance or through Amazon Relational Database Service (RDS). Running Oracle on EC2 and RDS are both viable options and offer unique advantages.
Generally, it's easier for enterprises to set up, manage and maintain Oracle on Amazon RDS than installing Oracle on EC2. RDS is highly scalable, and users can ramp the service up or down depending on compute needs. Licensing is handled through RDS per-hour fees, so there is no separate, long-term licensing.
RDS might also be a better option when a business needs to focus on tasks other than Oracle Database management. However, RDS is best served with databases smaller than 2.5 TB with storage I/O needs below 30,000 IOPS; larger databases and heavier storage use may require an EC2 deployment.
By comparison, running Oracle on EC2 provides control, flexibility and manageability of the application. A business that specializes in database use or requires full control over the application will probably benefit from an EC2 deployment. However, this requires detailing a deployment plan and application architecture. Cloud architects need to think about performance of the network and storage IOPS, resilience, backups for data protection, security and licensing. IT teams must control every aspect of the application's deployment.
Ultimately, the decision between RDS and EC2 deployments depends on size and performance needs, as well as management preferences.
What licenses do we need to run Oracle Database on AWS?
How can we approach an Oracle Database migration to AWS?
Oracle targets AWS with new services
Dig Deeper on AWS cloud development
Related Q&A from Stephen J. Bigelow
What is data separation and why is it important in the cloud?
Some enterprises avoid the public cloud due to its multi-tenant nature and data security concerns. Learn what data separation is and how it can keep ... Continue Reading
NAS vs. object storage: What's best for unstructured data storage?
There are advantages and disadvantages to using NAS or object storage for unstructured data. Find out what to consider when it comes to scalability, ... Continue Reading
Do hypervisors limit vertical scalability?
Knowing hardware maximums and VM limits ensures you don't overload the system. Learn hypervisor scalability limits for Hyper-V, vSphere, ESXi and ... Continue Reading