1 / 78

Running Oracle in EC2 Ahbaid Gaffoor Amazon/A9

Running Oracle in EC2 Ahbaid Gaffoor Amazon.com/A9.com. Overview. Section 1: Pricing and Licensing Section 2: Getting Started with AWS Section 3: Installing Oracle Section 4: Secure Backup. Section 1 Pricing and Licensing. Section 1: Pricing and Licensing.

maeve
Download Presentation

Running Oracle in EC2 Ahbaid Gaffoor Amazon/A9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Running Oracle in EC2Ahbaid GaffoorAmazon.com/A9.com

  2. Overview • Section 1: Pricing and Licensing • Section 2: Getting Started with AWS • Section 3: Installing Oracle • Section 4: Secure Backup Oracle on EC2, NoCOUG Aug 20th 2009

  3. Section 1 Pricing and Licensing Oracle on EC2, NoCOUG Aug 20th 2009

  4. Section 1: Pricing and Licensing • Amazon Web Services (AWS) Overview • Pricing of relevant AWS Services • Oracle Licensing and Support • Oracle Secure Backup Cloud Module Oracle on EC2, NoCOUG Aug 20th 2009

  5. 1.1 AWS Overview: • Amazon Elastic Compute Cloud (EC2) • Amazon Simple Storage Service (S3) • Amazon Cloud Front • Amazon SimpleDB • Amazon Simple Queue Service (SQS) • Amazon Elastic MapReduce Oracle on EC2, NoCOUG Aug 20th 2009

  6. 1.2 AWS Pricing EC2: • Elastic Compute Cloud (EC2) • Prices http://aws.amazon.com/ec2/#pricing • Amazon Machine Image (AMI): • On Demand, Reserved 1 Year, 3 Years • Standard CPU AMI: • Small $0.10/hr, $325/yr ($0.03/hr),$500/3yr • Large $0.40/hr, $1300/yr($0.12/hr),$2000/3yr • XLarge $0.80/hr, $2600/yr($0.24/hr),$4000/3yr • High CPU AMI: • Medium $0.20/hr, $650/yr($0.06/hr),$1000/3yr • XLarge $0.80/hr, $2600/yr($0.24/hr),$4000/3yr Oracle on EC2, NoCOUG Aug 20th 2009

  7. 1.2 AWS Pricing EC2 (Cont’d): • Elastic Compute Cloud (EC2) • Elastic IP • Public, Static IP • IP Map/Re-map > 100/month $0.10 each • $0.01 non-attached per hour • Elastic Block Store (EBS) • $0.10 GB/month provisioned • $0.10 per 1MM/month I/O requests • EBS Snapshots to S3 • $0.15 GB/month • $0.01 per 1,000 PUT requests (when saving a snapshot) • $0.01 per 10,000 GET requests (when loading a snapshot) Oracle on EC2, NoCOUG Aug 20th 2009

  8. 1.2 AWS Pricing S3: • Simple Storage Service (S3) • Prices http://aws.amazon.com/s3/#pricing • Operations: PUT, GET, DELETE • Storage • $0.15GB/Month < 50TB • $0.14GB/Month > 50TB, < 400TB • $0.13GB/Month > 400TB, < 500TB • $0.12GB/Month > 500TB • Data Transfer • $0.10GB all data transfer in Oracle on EC2, NoCOUG Aug 20th 2009

  9. 1.2 AWS Pricing S3 (Cont’d): • Requests • $0.01 per 1,000 PUT, COPY, POST or LIST request • DELETES are free • $0.01 per 10,000 GET and all other requests • AWS Import/Export • Device Handling $80.00 each • Data loading $2.49 per hr (hourly increment) Oracle on EC2, NoCOUG Aug 20th 2009

  10. 1.2 AWS Pricing Import/Export: • Not Database exp/imp • AWS Import/Export • Device Handling $80.00 each • Data loading $2.49 per hr (hourly increment) • http://aws.amazon.com/importexport/ • Calculator: http://awsimportexport.s3.amazonaws.com/aws-import-export-calculator.html Oracle on EC2, NoCOUG Aug 20th 2009

  11. 1.2 AWS Data Transfer Pricing: • Data Transfer: • Regions: US, EU • Sub-region (zone) • Free within zones on private IP • Elastic IP or Public IP outside AWS, regional charges Oracle on EC2, NoCOUG Aug 20th 2009

  12. 1.3 Oracle Licensing: • Existing or New License • http://www.oracle.com/corporate/pricing/cloud-licensing.pdf • Cost of AMI • Pre-built Oracle AMI (11g) • Roll your own AMI Oracle on EC2, NoCOUG Aug 20th 2009

  13. 1.3 Oracle Support: • Virtualization Support – AWS • Database Support • Oracle Secure Backup Cloud Module • http://www.oracle.com/technology/tech/cloud/faq.html#support • No RAC Oracle on EC2, NoCOUG Aug 20th 2009

  14. 1.4 Oracle Secure Backup Cloud Module: • Backups to S3 via. RMAN • 9i R2 and higher • Pre-installed on Oracle AMIs • EC2 and non-EC2 databases • Requires S3 and OTN accounts • Integrated with Enterprise Manager Oracle on EC2, NoCOUG Aug 20th 2009

  15. Section 2 Getting Started with AWS Oracle on EC2, NoCOUG Aug 20th 2009

  16. Section 2: Getting Started with AWS • AWS account • AWS EC2 Console • EC2 Security Groups • EC2 Key Pairs • EC2 Amazon Machine Images (AMIs) • EC2 Elastic IP • EC2 EBS Volumes • EC2 Snapshots • Using EC2 Command Line tools Oracle on EC2, NoCOUG Aug 20th 2009

  17. 2.1 AWS account • Amazon.com account • Sign up for services at http://aws.amazon.com • EC2 Console: http://console.aws.amazon.com Oracle on EC2, NoCOUG Aug 20th 2009

  18. 2.2 AWS EC2 Console Oracle on EC2, NoCOUG Aug 20th 2009

  19. 2.2 AWS EC2 Console • Security Groups • Key Pairs • AMIs • Instances • Elastic IPs • EBS Volumes • EBS Snapshots Oracle on EC2, NoCOUG Aug 20th 2009

  20. 2.3 EC2 Security Groups Oracle on EC2, NoCOUG Aug 20th 2009

  21. 2.3 EC2 Security Groups - Create Oracle on EC2, NoCOUG Aug 20th 2009

  22. 2.3 EC2 Security Groups – Configuration Oracle on EC2, NoCOUG Aug 20th 2009

  23. 2.4 EC2 Key Pairs Oracle on EC2, NoCOUG Aug 20th 2009

  24. 2.4 EC2 Key Pairs – Create Oracle on EC2, NoCOUG Aug 20th 2009

  25. 2.4 EC2 Key Pairs – Save PEM file Oracle on EC2, NoCOUG Aug 20th 2009

  26. 2.4 EC2 Key Pairs – Save PEM file • Only one opportunity • Make a copy • Make another offline copy • Cannot be retrieved or restored • PEM? Oracle on EC2, NoCOUG Aug 20th 2009

  27. 2.5 EC2 AMIs Oracle on EC2, NoCOUG Aug 20th 2009

  28. 2.5 EC2 AMIs – List Options • Show/Hide (Owner, Platform, Architecture) • Oracle owner id = 725966715235 • Linux only Oracle on EC2, NoCOUG Aug 20th 2009

  29. 2.5 EC2 AMIs – Launch Instance Oracle on EC2, NoCOUG Aug 20th 2009

  30. 2.5 EC2 AMIs – Instance Options Oracle on EC2, NoCOUG Aug 20th 2009

  31. 2.5 EC2 AMIs – Availability Zones • us-east-1a • us-east-1b • us-east-1c • us-east-1d Oracle on EC2, NoCOUG Aug 20th 2009

  32. 2.5 EC2 AMIs – Instance Launch Oracle on EC2, NoCOUG Aug 20th 2009

  33. 2.5 EC2 Instances - Pending Oracle on EC2, NoCOUG Aug 20th 2009

  34. 2.5 EC2 Instances – Launched Oracle on EC2, NoCOUG Aug 20th 2009

  35. 2.5 EC2 Instances – Command Line Tools • Scriptable command line tools: • ec2-bundle-instance • ec2-confirm-product-instance • ec2-describe-instances • ec2-describe-reserved-instances • ec2-describe-reserved-instances-offerings • ec2-monitor-instances • ec2-purchase-reserved-instances-offering • ec2-reboot-instances • ec2-run-instances • ec2-terminate-instances • ec2-unmonitor-instances Oracle on EC2, NoCOUG Aug 20th 2009

  36. 2.6 EC2 Elastic IP • Static IP tied to account • Assign to any account instance • Unassigned is more expensive • Redirect failed services • Scriptable command line tools: • ec2-allocate-address • ec2-associate-address • ec2-disassociate-address • ec2-release-address Oracle on EC2, NoCOUG Aug 20th 2009

  37. 2.6 EC2 Elastic IPs Oracle on EC2, NoCOUG Aug 20th 2009

  38. 2.6 EC2 Elastic IP - Allocate Oracle on EC2, NoCOUG Aug 20th 2009

  39. 2.6 EC2 Elastic IP - Allocated Oracle on EC2, NoCOUG Aug 20th 2009

  40. 2.6 EC2 Elastic IP - Associate Oracle on EC2, NoCOUG Aug 20th 2009

  41. 2.6 EC2 Elastic IP - Associated Oracle on EC2, NoCOUG Aug 20th 2009

  42. 2.7 EC2 Elastic Block Store (EBS) Volumes • Persistent Storage • Pick zone and region • Assign to an instance within a zone • Scriptable command line tools: • ec2-create-volume • ec2-delete-volume • ec2-attach-volume • ec2-detach-volume • ec2-describe-volume Oracle on EC2, NoCOUG Aug 20th 2009

  43. 2.7 EC2 EBS Volumes Oracle on EC2, NoCOUG Aug 20th 2009

  44. 2.7 EC2 EBS Volumes - Create Oracle on EC2, NoCOUG Aug 20th 2009

  45. 2.7 EC2 EBS Volumes - Creating Oracle on EC2, NoCOUG Aug 20th 2009

  46. 2.7 EC2 EBS Volumes - Created Oracle on EC2, NoCOUG Aug 20th 2009

  47. 2.7 EC2 EBS Volumes - Attach Oracle on EC2, NoCOUG Aug 20th 2009

  48. 2.7 EC2 EBS Volumes - Attached Oracle on EC2, NoCOUG Aug 20th 2009

  49. 2.8 EC2 EBS Snapshots • Copy of EBS Volume into S3 • S3 replicates snapshots across zones • Snapshots restorable in any zone • Snapshots used to copy EBS volumes within zones • Scriptable command line tools: • ec2-create-snapshot • ec2-delete-snapshot • ec2-describe-snapshot Oracle on EC2, NoCOUG Aug 20th 2009

  50. 2.8 EC2 EBS Snapshots Oracle on EC2, NoCOUG Aug 20th 2009

More Related