Cloud Computing with Amazon and Oracle Lewis Cunningham

1
Cloud Computing withAmazon and Oracle
Lewis Cunningham TUSC, Sr Datawarehouse
Consultant http//it.toolbox.com/blogs/oracle-guid
e http//databasewisdom.com/
12/11/2008
2
Introduction

• Oracle ACE Director
• Author
• Former Cloud Architect for EnterpriseDB
• Currently Data Warehouse Consultant for TUSC
• Blogger, An Expert's Guide to Oracle Technology

3
My New Bookhttp//sqlstarter.com
4
Agenda

• What Is Cloud Computing?
• What Does Amazon Offer?
• The Value Proposition
• Where Does Oracle Fit In?
• How Does Amazon Work?

5
What is Cloud Computing?
Cloud computing is using the internet to access
someone else's software running on someone else's
hardware in someone else's data center.
- Lewis Cunningham
6
Distributed Computing

• Remember SETI_at_Home?
• Heard of HADOOP?
• Grid Computing
• Distributed computing is spreading a large task
  over many machines
• Distributed computing can be cloud computing but
  is not cloud computing

7
Software as a Service - SaaS

• Gmail Yahoo Mail
• Google Docs
• Mozy Online Backups
• CRM
• Remember Application Service Providers?
• The next big thing of 2000 that didn't
  happen.

8
Platform as a Service - PaaS

• Salesforce.com
• Google App Engine
• Aptana
• Provides a development platform and hosting

9
Infrastructure as a Service - IaaS

• Amazon Web Services (AWS)
• EMC Fortress (Storage Cloud)
• HP Adaptive IaaS
• WIPRO, CISCO, IBM, Sun
• Everybody and their brother

10
Infrastructure as a Service - IaaS

• Key Features
• Virtualization
• Nearly instance scalability
• Everything is a service
• Utility style (pay for what you use)
• Hardware, OS, Software, Storage Network

11
What Does Amazon Offer? Electronic Compute
Cloud EC2

• Hardware Virtualization
• Amazon Machine Image (AMI)
• CPU, Memory, Storage
• Linux, Solaris, Windows
• Safety
• Coming Soon - Regions
• Availability Zones

12
What Does Amazon Offer? Electronic Compute
Cloud EC2

• Elastic Internet (IP) Addresses
• Dynamic Addition
• Dynamic Reallocate
• Security
• XEN Hypervisor
• Disk encryption is your call
• Security Groups controls access

13
What Does Amazon Offer? Electronic Compute
Cloud EC2

• Storage is Transient
• S3
• EBS
• SLA
• Amazon warrants 99.95 uptime
• lt99.95 gets a 10 discount

14
What Does Amazon Offer? Electronic Compute
Cloud EC2

• Computing Power based on a Compute Unit
• 1 Compute Unit 1 Circa 2007 1.0-1.2 GHz Opteron
  or Xeon CPU
• Cost is based on Memory, Storage and Compute Units

15
What Does Amazon Offer? Electronic Compute
Cloud EC2
16
What Does Amazon Offer? Simple Storage Service
S3

• API Driven Storage
• Get, Put and Delete
• Organized around buckets
• Bucket like a directory
• Bucket can hold objects or more buckets
• Objects can be up to 5gb each

17
What Does Amazon Offer? Simple Storage Service
S3

• Access
• Fast
• Reliable
• HTTP REST or SOAP
• Secure
• Access Control Lists (ACL)
• Transfer uses SSL (encryption)
• Can encrypt data at rest

18
What Does Amazon Offer? Simple Storage Service
S3
19
What Does Amazon Offer? Simple Storage Service
S3
20
What Does Amazon Offer? Simple Storage Service
S3
21
What Does Amazon Offer? Simple Storage Service
S3

• SLA
• 99.9 Uptime Guarantee
• If Between 99 and 99.9 Uptime
• 10 Credit
• If lt99 Uptime
• 25 Credit

22
What Does Amazon Offer? Elastic Block Storage -
EBS

• Like a USB Drive
• Portable between AMIs
• Persistent
• Dynamically add and remove
• Snapshots
• 10 cents per GB per month
• 10 cents per 1 million IOs per month

23
What Does Amazon Offer? Simple Queue Service -
SQS

• Like Oracle AQ or IBM MQ Series
• API based
• Many interfaces
• Ruby, Java, Python, etc
• 8k messages and unlimited queues
• 1 cent per 10000 requests
• Data transfer in and out of Amazon costs

24
What Does Amazon Offer? Simple DB

• Amazon's first public web service
• Very, very, very simple database
• Not relational
• Key/Value Pairs
• Non-SQL
• Not cheap, 1.500.25/GB/Month
• Plus data transfer costs

25
What Does Amazon Offer? Value Proposition

• Economics
• Dev Test no upfront capital
• If you buy, buy exactly what you need
• Pay for what you use
• Pay as you go
• Easier
• Faster

26
Where Does Oracle Fit In?

• Oracle AMIs
• Oracle 11g EE, SE SE1 32-Bit
• Oracle 11g EE, SE SE1 64-Bit
• Oracle 10g XE
• Oracle Hyperion Essbase
• You can run OBIEE
• You can run Application Server
• Oracle provides licensing and support

27
Where Does Oracle Fit In?

• Oracle Secure Backup Cloud Module
• RMAN to S3, 9iR3 higher
• Can run using OEM
• 32-Bit Linux and Windows
• More reliable than tape
• Faster than tape (40-50MB/Sec)
• Takes care of off site storage

28
Where Does Oracle Fit In?

• Oracle Secure Backup Cloud Module
• Automatically Encrypts
• Will use Oracle 11g Fast Compressed Backup
  (normally requires Advanced Compression license)
  at no cost
• No more mounting tapes
• Cheap, Cheap, Cheap

29
Where Does Oracle Fit In?Oracle Cloud Control
30
How does Amazon work?

• Command Line Tools (Yuck)
• 3rd Party Add-ons
• ElasticFox (1)
• Cloud Studio
• 3rd Party Vendors
• RightScale
• Elastra
• This demo will use ElasticFox

31
Elastic Fox
32
Credentials
33
SSH Key Pairs
34
Security Group
35
Elastic IPs
36
Elastic Block Storage Create Volume
37
Elastic Block Storage Unattached Volume
38
Current Availability Zones
39
Oracle AMIs
40
Start an Instance
41
Pending Instance
42
Instance Details
43
Attach an Elastic IP
44
Attached Elastic IP
45
Elastic Block Storage Attach Volume
46
Elastic Block Storage Attach Volume Popup
47
Elastic Block Storage Attached Volume
48
Instance Startup Console Output
49
Oracle Started
50
SSH to Instance
51
Oracle License Agreement
52
Set Oracle Password
53
Ready to Rumble
54
Mount an ext2 Filesystem on EBS Volume
/sbin/mke2fs -j /dev/sdg echo "/dev/sdg /vol
ext3 noatime 0 0" gtgt /etc/fstab mkdir
/vol mount /vol df --si
55
Verify EBS Volume df -si
56
AWS ApEx
57
Cloud Computing with Amazon and Oracle
Lewis Cunningham TUSC, Sr Datawarehouse
Consultant http//it.toolbox.com/blogs/oracle-guid
e http//databasewisdom.com/
12/11/2008