Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Configuring RAC on Amazon Cloud

Hello All,

This post is specifically for those who works on Amazon Cloud and want to build a RAC on Amazon EC2 Instances (machines).

There is a very good article in the AWS Documentation Articles (here), but the linux instances taken and built were very large and per hour it cost around 4$ each machine (three machines).

For those who are looking for a cost effective testing solution, I have tried to built the RAC on m3.medium instances which costs around 15Cents per hour. Which I think phenomenal cheap. Finally, my verdict its not that easy to have the machines ready and also the following issues (at least to my knowledge, I welcome if anyone can correct me here)

  • Multicast Support on EC2 Instance IP not supported: Due to this we have to rely on Ntop N2N (kind of VPN) which transmits multicast packets across nodes
  • Although used N2N, the cluster haip having issues, this means you cannot have multiple private networks
  • Public VIP that means Node VIP and SCAN VIP cannot be failed over as well unless you create a specific failover script to right instances
  • You cannot use server pools concept since the VIP assignments are static to the nodes.

Despite of having all this , if you want to check here are the steps.

The following steps assumes

  • You have an AWS account and a EC2 instance with AWS CLI installed

Node Configurations

 

Details

Sto.geeklabs.com

Db1.geeklabs.com

Db2.geeklabs.com

AWS Type

Ec2

Ec2

Ec2

Instance Class

M3.medium

M3.medium

M3.medium

Multicast Support

Ntop- Super Node

Ntop – edge

Ntop-edge

Shared Storage

iSCSi  Target

iSCSi Initiator

iSCSi Initiator

Storage Type

EBS/Magnetic

EBS/Magnetic

EBS/Magnetic

Storage Size

Root Volume – 20gb

EBS Volumes – 10 gb * 2

Root Volume- 20gb

Root Volume -20gb

VPC

Custom VPC

Internet gate Way Enabled

Custom VPC

Internet gate Way Enabled

Custom VPC

Internet gate Way Enabled

Public Subnet

Subnet 1 : 10.0.0.74

Subnet 1 : 10.0.0.233

Subnet 1 : 10.0.0.83

Secondary Public IP’s

Nil

Subnet 1 : 10.0.0.100 (VIP)

Subnet 1 : 10.0.0.101 (SCAN)

Subnet 1 : 10.0.0.102 (SCAN)

Subnet 1 : 10.0.0.103 (SCAN)

Subnet 1 : 10.0.0.104 (VIP)

Private Subnet

Nil

Subnet 2: 10.0.1.21

Subnet 2: 10.0.1.22

OS - AWS Image

OEL 5.11 UEK

ami-c5b2dfff

OEL 5.11 UEK

ami-c5b2dfff

OEL 5.11 UEK

ami-c5b2dfff

 

 

 

 

Installation Document

 

Comments are closed.