Re: oracle on EC2
Date: Tue, 12 Jan 2016 08:57:00 -0600
Message-ID: <CAJueESqm3UZJPM-dvO1B7_gk=92dV1vUEcuTat+2ffK8UPvGOA_at_mail.gmail.com>
Provided that you don't include the OJVM PSU. That's a pretty big caveat, IMO. On Tue, Jan 12, 2016 at 8:42 AM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:
> Rolling patching.
>
> Seth Miller
>
> On Mon, Jan 11, 2016 at 10:37 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> Yes, I can understand how it can be done. But I can't think of any
>> reason why.
>>
>> Sent from my iPad
>>
>> On Jan 11, 2016, at 10:25 PM, Thomas Roach <troach_at_gmail.com> wrote:
>>
>> Here is a document from Oracle about running RAC in public clouds.
>>
>>
>> http://www.oracle.com/technetwork/database/options/clustering/overview/rac-cloud-support-2843861.pdf
>>
>> Sent from my iPhone
>>
>> On Jan 11, 2016, at 8:06 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
>> wrote:
>>
>> I just can't think of a use case of RAC on EC2. Can someone enlighten
>> me.
>>
>> Sent from my iPad
>>
>> On Jan 11, 2016, at 9:17 PM, Jeremiah Wilton <jcwilton93_at_earlham.edu>
>> wrote:
>>
>> I wrote this to help people who want to see if RAC on EC2 will work for
>> them.
>>
>> https://aws.amazon.com/articles/7455908317389540
>>
>> Jeremiah
>>
>> Sent from my iPhone
>>
>> On Jan 11, 2016, at 7:12 PM, soumya das <soumya2home_at_gmail.com> wrote:
>>
>> Hi guys,
>>
>> Thanks for all the valuable input. I have a question even though its not
>> entirely related to subject. Is it possible to create a RAC setup on ec2 ?
>> I did few googling and found that aws still doesnt support it. Has anyone
>> of you tried it or have any clear picture on this? If you do please share
>> your opinion.
>> Thanks,
>>
>> Soumya
>>
>> On Tue, Jan 12, 2016 at 1:10 AM, Jeremiah Cetlin Wilton <
>> jcwilton93_at_earlham.edu> wrote:
>>
>>> Right.
>>>
>>> This is the license-related doc:
>>>
>>> http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
>>>
>>> These are the docs to address the hypervisor support issue:
>>>
>>> https://support.oracle.com/epmos/faces/DocumentDisplay?id=1901155.1
>>>
>>> http://aws.amazon.com/articles/7455908317389540#FAQ1
>>>
>>> Jeremiah
>>>
>>> ------------------------------
>>> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
>>> *To: *"Jeremiah Cetlin Wilton" <jcwilton93_at_earlham.edu>
>>> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
>>> oracle-l_at_freelists.org>, "Maris Elsins" <elmaris_at_gmail.com>
>>> *Sent: *Monday, January 11, 2016 11:15:16 AM
>>> *Subject: *Re: oracle on EC2
>>>
>>> Neither of these links reference licensing.
>>>
>>> Seth Miller
>>>
>>> On Mon, Jan 11, 2016 at 12:55 PM, Jeremiah Cetlin Wilton <
>>> jcwilton93_at_earlham.edu> wrote:
>>>
>>>> Not really. There's also a doc for that :-)
>>>>
>>>> https://support.oracle.com/epmos/faces/DocumentDisplay?id=1901155.1
>>>>
>>>> I talk about it a little bit here:
>>>>
>>>> http://aws.amazon.com/articles/7455908317389540#FAQ1
>>>>
>>>> Jeremiah
>>>>
>>>> ------------------------------
>>>> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
>>>> *To: *"Jeremiah Cetlin Wilton" <jcwilton93_at_earlham.edu>
>>>> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
>>>> oracle-l_at_freelists.org>, "Maris Elsins" <elmaris_at_gmail.com>
>>>> *Sent: *Monday, January 11, 2016 10:50:36 AM
>>>>
>>>> *Subject: *Re: oracle on EC2
>>>>
>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>
-- "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 12 2016 - 15:57:00 CET