Re: oracle on EC2
Date: Mon, 11 Jan 2016 12:50:36 -0600
Message-ID: <CAEueRAW9Mgk4DRA-TKbpkFkqG_YHFcqjDSWSVPZEb3EDi3jQkA_at_mail.gmail.com>
Does this mean that you have to make sure you are running EC2 instances in an Oracle VM hypervisor?
Seth Miller
On Mon, Jan 11, 2016 at 12:27 PM, Jeremiah Cetlin Wilton < jcwilton93_at_earlham.edu> wrote:
> There's a doc for that:
>
> http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
>
> Jeremiah
>
> ------------------------------
> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
> *To: *elmaris_at_gmail.com
> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
> oracle-l_at_freelists.org>
> *Sent: *Monday, January 11, 2016 10:20:28 AM
> *Subject: *Re: oracle on EC2
>
> Maris,
>
> How are you licensing these databases?
>
> Seth Miller
>
> On Mon, Jan 11, 2016 at 9:29 AM, Maris Elsins <elmaris_at_gmail.com> wrote:
>
>> Hi,
>>
>> We're running a configuration that addresses some of your IOPS concerns
>> and it's basically one of the architectures from this whitepaper
>> https://d0.awsstatic.com/whitepapers/aws-advanced-architectures-for-oracle-db-on-ec2.pdf
>>
>> - We have created our EC2 for Oracle DBs using Oracle Linux 6
>> (requirement for Oracle Smart Flash Cache)
>> - We've set up ASM on multiple provisioned IOPS EBS volumes (SSD) for
>> striping
>> - We've enabled Oracle Smart Flash Cache on part of the ephemeral
>> instance store SSD (it doesn't have even the tiny network latency that EBS
>> volumes have, as they are local). And based on the AWR reports we see this
>> works very well. And in fact with larger EC2 instances one gets plenty of
>> instance store SSDs that otherwise are of no big use.)
>> - We don't rely on EBS volumes' snapshots for backups, as we have a
>> DataGuard set up and when needed we stop the recovery there and take
>> snapshots from it (for cloning purposes usually). I'd think this would also
>> work with "ALTER DATABASE BEGIN/END BACKUP" + simultaneous snapshot of all
>> striped EBS volumes too.
>> - We take regular RMAN backups for point in time recovery requirements.
>>
>> May be this is not exactly what you were looking for as you provided a
>> link related to RAID configurations, but probably you can still extract
>> something useful from what I wrote.
>>
>> regards,
>>
>> ---
>> Maris Elsins
>> _at_MarisElsins <https://twitter.com/MarisElsins>
>> www.facebook.com/maris.elsins
>>
>>
>>
>> On Mon, Jan 11, 2016 at 4:44 PM, max scalf <oracle.blog3_at_gmail.com>
>> wrote:
>>
>>> Hello all,
>>>
>>> This question is related to running oracle database on Amazon Web
>>> Service. Just so i respect everyone's time on here, I would say please
>>> ignore this question if you do not work with AWS.
>>>
>>> We are running oracle some 11g and 12c database on AWS EC2 server. Most
>>> of the server have anywhere from 2 -8 EBS Volume attached(general purpose
>>> SSD), they are NOT striped or mirrored. Lately we have been seeing some
>>> performance issue(year end closing) with high IO wait time(60-80 ms per
>>> read), for some mission critical application we have moved the EBS volumes
>>> from general purpose SSD to Provisioned IOPS(PIOPS) and everything seems
>>> happy. But now we are coming back to some of the other application and our
>>> sysadmin says instead of moving everything from general purpose volumes to
>>> PIOPS we should just strip the volumes to get better performance.
>>>
>>> I agree with him, but my question if we were to strip the EBS volumes
>>> how do we deal with taking EBS Snapshot and managing them. We rely on them
>>> for our DR in another region. From what i understand about taking snapshot
>>> when your EBS volumes are stripped is that you have to freeze the IO before
>>> you do the snapshot to guarantee EBS snapshot consistency, see below link..
>>>
>>>
>>> https://aws.amazon.com/premiumsupport/knowledge-center/snapshot-ebs-raid-array/
>>>
>>> So i wanted to see what others are doing in the community
>>> to achieve higher IOPS and i am sure quite a few ppl are running oracle on
>>> AWS and also I wanted to find out when they say "Freeze IO", I am assuming
>>> putting database in HOT BACKUP mode is the wrong thing.
>>>
>>>
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 11 2016 - 19:50:36 CET