view the deck as powerpoint

1

Cloud Computing withAmazon and Oracle

Lewis CunninghamTUSC, Sr Datawarehouse Consultanthttp://it.toolbox.com/blogs/oracle-guidehttp://databasewisdom.com/ 12/11/2008

2

IntroductionIntroduction

• 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 BookMy New Bookhttp://sqlstarter.comhttp://sqlstarter.com

4

AgendaAgenda

• 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?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 ComputingDistributed Computing

• Remember SETI@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 - SaaSSoftware 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 - PaaSPlatform as a Service - PaaS

• Salesforce.com• Google App Engine• Aptana

• Provides a development platform and hosting

9

Infrastructure as a Service - Infrastructure as a Service - IaaSIaaS• Amazon Web Services (AWS)• EMC Fortress (Storage Cloud)• HP Adaptive IaaS• WIPRO, CISCO, IBM, Sun• Everybody and their brother

10

Infrastructure as a Service - Infrastructure as a Service - IaaSIaaSKey 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? What Does Amazon Offer? Electronic Compute Cloud – EC2Electronic Compute Cloud – EC2

• Hardware Virtualization• Amazon Machine Image (AMI)• CPU, Memory, Storage• Linux, Solaris, Windows

• Safety• Coming Soon - Regions• Availability Zones

12


• Elastic Internet (IP) Addresses• Dynamic Addition• Dynamic Reallocate

• Security• XEN Hypervisor• Disk encryption is your call• Security Groups controls access

13


• Storage is Transient• S3• EBS

• SLA• Amazon warrants 99.95% uptime• <99.95 gets a 10% discount

14


• 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


Instance Type MemoryCompute Units

Storage PlatformLinux CPU/Hour

Windows CPU/Hour

Small 1.7GB 1 160GB 32-bit $0.10 $0.125

Large 7.5GB 4 850GB 64-bit $0.40 $0.50

Extra Large 15GB 8 1690GB 64-bit $0.80 $1.00

High CPU,Medium

1.7GB 5 350GB 32-bit $0.20 $0.30

High CPU, Large

7GB 20 1690GB 64-bit $0.80 $1.20

16

What Does Amazon Offer? What Does Amazon Offer? Simple Storage Service – S3Simple 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


• Access• Fast• Reliable• HTTP – REST or SOAP

• Secure• Access Control Lists (ACL)• Transfer uses SSL (encryption)• Can encrypt data at rest

18


Storage, US per GB Europe per GB

First 50TB/Month $0.150 $0.180

Next 50TB/Month $0.140 $0.170

Next 400TB/Month $0.130 $0.160

Over 500TB/Month $0.120 $0.150

19


Data Transfer US per GB Europe per GB

Transfer Into S3 $0.100 $0.100

First 10TB Out of S3 $0.170 $0.170

Next 40TB Out of S3 $0.130 $0.130

Next 100TB Out of S3 $0.110 $0.110

Out over 150TB $0.100 $0.100

20


Requests US per Request Europe per Request

Put, Copy, List, Post $0.01 $0.012

Delete (always free) $0.00 $0.00

Get and all other requests

$0.01 $0.012

21


• SLA• 99.9% Uptime Guarantee• If Between 99% and 99.9% Uptime

• 10% Credit• If <99% Uptime

• 25% Credit

22

What Does Amazon Offer? What Does Amazon Offer? Elastic Block Storage - EBSElastic 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? What Does Amazon Offer? Simple Queue Service - SQSSimple 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? What Does Amazon Offer? Simple DBSimple DB• Amazon's first public web service• Very, very, very simple database• Not relational • Key/Value Pairs• Non-SQL• Not cheap, $1.50$0.25/GB/Month• Plus data transfer costs

25

What Does Amazon Offer? Value What Does Amazon Offer? Value PropositionProposition

• 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?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


• 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


• 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?Where Does Oracle Fit In?Oracle Cloud ControlOracle Cloud Control

30

How does Amazon work?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 FoxElastic Fox

32

CredentialsCredentials

33

SSH Key PairsSSH Key Pairs

34

Security GroupSecurity Group

35

Elastic IPsElastic IPs

36

Elastic Block Storage Create VolumeElastic Block Storage Create Volume

37

Elastic Block Storage Unattached Elastic Block Storage Unattached VolumeVolume

38

Current Availability ZonesCurrent Availability Zones

39

Oracle AMIsOracle AMIs

40

Start an InstanceStart an Instance

41

Pending InstancePending Instance

42

Instance DetailsInstance Details

43

Attach an Elastic IPAttach an Elastic IP

44

Attached Elastic IPAttached Elastic IP

45

Elastic Block Storage Attach VolumeElastic Block Storage Attach Volume

46

Elastic Block Storage Attach Volume Elastic Block Storage Attach Volume PopupPopup

47

Elastic Block Storage Attached VolumeElastic Block Storage Attached Volume

48

Instance Startup Console OutputInstance Startup Console Output

49

Oracle StartedOracle Started

50

SSH to InstanceSSH to Instance

51

Oracle License AgreementOracle License Agreement

52

Set Oracle PasswordSet Oracle Password

53

Ready to RumbleReady to Rumble

54

Mount an ext2 Filesystem on EBS Mount an ext2 Filesystem on EBS VolumeVolume

/sbin/mke2fs -j /dev/sdg

echo "/dev/sdg /vol ext3 noatime 0 0" >> /etc/fstab

mkdir /vol

mount /vol

$ df --si

55

Verify EBS Volume df -siVerify EBS Volume df -si

56

AWS ApExAWS ApEx

57

Cloud Computing with Amazon and Oracle

Lewis CunninghamTUSC, Sr Datawarehouse Consultanthttp://it.toolbox.com/blogs/oracle-guidehttp://databasewisdom.com/ 12/11/2008

view the deck as powerpoint

Documents

cloud computing

amazon offer

cloud architect

amazon work

service paas

elses hardware

elses software

application service