Re: Oracle running on AWS RDS (or SQL Server on AWS RDS)
- From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
- To: Oracle-L List <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 23 Nov 2013 20:46:05 -0800 (PST)
Hi Sandra,
Welcome to the world of Cloud Computing :) Given the choice, I'd go with EC2
instance with EBS instead of RDS, given that you will have more flexibility,
configuration options, monitoring capability. With RDS, you get basic
administration covered, have automatic monitoring, snapshots, backups etc from
AWS personnel. Please note that EVEN with multiple Availability Zones(AZs)
configured, RDS (last time I checked) still cannot operate across regions. If
an entire region goes down (and this has happened a few times in the past 3
years), the DB and the app will be completely down.
So, it is very important that you consider a setup HA within the same region
and DR is configured in a completely different region. Also, please ensure that
there are app farms local to each DB. Although technically possible, please do
not have the app farm in different AZ from the DB, let alone have the apps "in
house" and point ONLY to the DB on EC2. When you go to EC2, everything needs to
be on EC2 (app servers, web servers, db servers), if you have latency-sensitive
applications.
Basically with RDS you will get what Amazon offers via the standard management
portals, CLIs and the APIs. Performance tuning can be a challenge, as every
issue that requires a change, will require interaction with AWS personnel. No
Data Guard, Active Data Guard, RAC, ASM etc with RDS. Not sure what your
day-to-day operation style is, but if you are like a regular DBA, you will feel
extremely constrained with RDS. RDS is primarily marketed for databases where a
full-time DBA is not required. With RDS, AWS takes on the onus of basic
administration, monitoring and running your DB.
With EC2, you get the "virtual machine" and all the benefits the Cloud
Computing offers (elasticity etc) and it is business as usual if you are
regular DBA. You are responsible for everything (configuration, monitoring,
backups, maintenance etc). You pretty much get everything you have "in house"
with Oracle. You also have the choice of BYOL (Bring Your Own License). Make
sure you do your homework with your existing setup, to ensure that you get
enough "provisioned IOPS" for your EC2 instance. EBS with RAID0 is something to
seriously consider. Given that EBS automatically replicates volumes for you,
using RAID0 will provide better performance here versus RAID10. Point to note -
Take frequent snapshots. Calculate your peak IOPS and throughput (transfer
rates) and incorporate them into your design of the EC2 instance. These will be
extremely critical/crucial for DB performance, so please nail that down really
well. Also, please make sure that you design
and test your HA and DR setup across regions.
From an AWS cost perspective, comparable RDS and EC2 instances are pretty
close, but the cost of YOU (and your fellow DBAs) undertaking all DB operations
needs to be factored into the final number. I hope this gives you some
perspective on the choices you have. I am referring to the EC2 Amazon Machine
Image (AMI) for Oracle. Here are some links with those choices listed:
- http://aws.amazon.com/running_databases/
- http://aws.amazon.com/running_databases/#relational_amis
- http://aws.amazon.com/oracle/
- http://media.amazonwebservices.com/AWS_RDBMS_Oracle.pdf (Whitepaper
describing options including provisioned IOPS)
- https://aws.amazon.com/amis/oracle/
May the force be with you :)
Cheers,
Gaja
Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com
Phone - +1 (650) 743-6060
LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
Co-author: Oracle Insights:Tales of the Oak Table -
http://www.apress.com/9781590593875
Primary Author: Oracle Performance Tuning 101 - http://www.amzn.com/0072131454
Enabling Exadata, Big Data and Cloud Deployment & Management for Oracle
________________________________
From: Sandra Becker <sbecker6925@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, November 13, 2013 12:49 PM
Subject: Oracle running on AWS RDS (or SQL Server on AWS RDS)
We are currently evaluating running a new database on Amazon Web Service
Relational Database Service. The decision hasn't been made whether to run an
Oracle or a SQL Server database. Another DBA stood up a SQL Server database on
AWS, but was unimpressed with the performance.
Does anyone have any experience setting up Oracle on AWS? What are the
pros/cons? We must run EE 11.2; no other versions are acceptable at this time.
Thanks for your input.
--
Sandy
Transzap, Inc.
Other related posts:
