AWS high memory instance type : Good for Oracle Databases on AWS

The r3.8xlarage has 244 GiB of memory, 32 vCPUs, and 2 - 320 GB SSD drives. The cost is $2.80 per hour for on-demand instances.  More details here:

http://aws.amazon.com/about-aws/whats-new/2014/04/10/r3-announcing-the-next-generation-of-amazon-ec2-memory-optimized-instances/

Prior to this you had to use the i2.8xlarge instance type which also has 244 GiB of memory and 32 vCPUs. But also has 8 - 800 GB SSD drives which you will most likely not use for your Oracle Database.  The cost of i2.8xlage is $6.82 per hour for on-demand instances.  The other highest memory option is the cr1.8xlarge with 32 vCPUs and 244 GIB with 2 -120 GB SSD drives.  The cost of this option is $3.50 per hour for on-demand instances.

The R3 instances include the following features:

• Intel Xeon E5-2670 v2 "Ivy Bridge" Processors

• Hardware Virtualization (HVM) only

• SSD-backed instance storage, including TRIM support

• Enhanced Networking with lower latency, low jitter, and high packet-per-second performance

One caveat here that Oracle has not released any HVM-based instance types.  There are undocumented methods to create an HVM AMI from a PVM AMI but this new AMI may not be supported by Oracle.

Data Center Migration to AWS

Learn how RISO Inc. used Apps Associates services to move their data center to the AWS cloud. In so doing, RISO Inc. avoided capital intensive hardware purchases and redeployed IT staff to projects that directly supported their business goals. We'll also describe how you can integrate your existing environment with the cloud to create a hybrid architecture.

http://youtu.be/jE1-8vjMGrw 

http://www.slideshare.net/AmazonWebServices/aws-partner-webcast-33342744 

http://www.slideshare.net/tomlaszewski/data-center-migration-to-the-aws-cloud

AWS Boston events coming soon

Here are some event that are happening in Boston the week of April 21:

Register today for the AWS Cloud Roadshow Series for SLED.

https://ww2.eventrebels.com/er/Registration/StepRegInfo.jsp?ActivityID=10424&StepNumber=1

AWS AwSome Day Boston :  free, one-day event 

Oracle RDS GoldenGate support

Oracle GoldenGate can be used with Amazon RDS for Oracle for active-active database replication, zero-downtime migration and upgrades, disaster recovery and data protection, and cross region replication. 

More information here: http://aws.amazon.com/about-aws/whats-new/2014/04/03/you-can-now-use-oracle-goldengate-with-amazon-rds-for-oracle/

Oracle Spatial on Amazon EC2

This presentation has details on an Oracle Spatial implementation on AWS. http://download.oracle.com/otndocs/products/spatial/pdf/osuc2012_presentations/osuc12_gisasservice_walshbaynham.pdf

The summary is:

• Technical approach:

  ·   Oracle Database with Spatial

  ·   Deploy on Amazon EC2

  ·   J2EE Web Application Server

  ·   Multi-tenant Multi-user 100% Web software for Mapping and analyzing business data 
– eSpatial OnDemand GIS

  
  

  Amazon Overview

  ·      Elastic Cloud Computing (EC2)


  ·      Variety of Instance Types (CPU cores, memory...)

  ·      Pre-configured Amazon Machine Instances (AMI’s)

  ·      Availability Zones

  ·      Elastic Block Storage – EBS
 Simple Storage Service (S3)
 Elastic IP addresses


  ·      Load Balancing & Auto Scaling, More...

  Amazon Deployment:

  ·   Dedicated Database Server(s) with separate Web Application Servers

  ·   AMI - Oracle 11g DB & Redhat Fedora

  ·   Database on an EBS volume

  ·   ARCHIVELOG as normal – archive to a separate EBS volume

  ·   RMAN Backup to separate EBS volume

  ·   Copy backups to Amazon S3

  ·   EE & RAC or SE-1 with Standby DB

  ·   Backup from Standby DB

  
  

Oracle Collaborate 2014 AWS sessions

Here are the three AWS focused sessions at Oracle Collaborate http://collaborate14.com

564: Best Practices for Running Oracle Databases on Amazon Web Services (AWS)   -- Speakers: Abdul Sait
Date: 04/11/2014
Time: 8:30 AM
Location: Level 3, Lido 3101B

Deploying PeopleSoft to the Amazon Cloud  --  Speakers: Abdul Sait, David Brunet

9 Apr 08:30 AM-09:30 AM

Session ID: 106940
Room: Level 4, Lando 4301B

OEM 12c session with Oracle Product Management and App Associates:

Workshop: Simplify, Automate, and Enhance Management of E-Business Suite (EBS) Applications

Monday, April 7 1:00 PM - 4:00 PM

Level 1 Sands 101

15526

This is a paid workshop.  More information here:
https://blogs.oracle.com/oem/entry/focus_on_oracle_applications_management

IAM : AWS services not supported and tagging support

I often get the question of which services do not support IAM?  Some services and features do not support IAM and must use the AWS root account credentials:

• Vulnerability Scanning Coordination Form
• AWS Workspaces
• Visibility of all Data Pipelines
• Specific account management pages, such as account profile, AWS account security credentials, payment methods and management of consolidated billing 
• AWS DevPay 
• CloudFront keypair creation

A full list of supported services is here:
http://docs.aws.amazon.com/IAM/latest/UserGuide/Using_SpecificProducts.html

This page also provides a great list of IAM resource level permissions support, tagging, and STS.