Re: Storage choice for Oracle database on VMware

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 30 Oct 2018 19:12:05 +0100
Message-ID: <CAGJBphSU3fiM8x5JXE5nELVcBQfMieqhCcz4wD==zrcX+U6dSA_at_mail.gmail.com>



Thank you Chris, Matthew and Niall,

so the question is if performancewise ASM is worth it.

With the default Oracle database settings the I/O on XFS would be synchronous, right?

And if I understand correctly Note 1987437.1, on Linux you cannot enable async I/O without turning on direct I/O too.

Regards
Dimitre

Il mar 30 ott 2018, 19:06 <niall.litchfield_at_gmail.com> ha scritto:

> ASM also requires 8GB ram in 18. In a vm environment that's a pretty big
> overhead. Not a reason not to do it, but a consideration. You'll also want
> to think about what your admins are used to and what vmware refer to as day
> 2 operations. Disk add, FS expansion, backup etc. There are some specifics
> for vmware for databases that you may find your vm admins don't immediately
> buy into.
>
> On Tue, 30 Oct 2018, 17:38 Matthew Parker, <dimensional.dba_at_comcast.net>
> wrote:
>
>> It is always a choice.
>>
>> If you decide to use filesystems then XFS, although for some reasons
>> based on your storage team you may only have NFS available.
>>
>> ASM still holds a performance advantage over XFS, but not by much.
>>
>> Extra GRID Infrastructure SW with patching for ASM versus simple XFS file
>> systems.
>>
>>
>>
>> *Matthew Parker*
>>
>> *Chief Technologist*
>>
>> *Dimensional DBA*
>>
>> *Oracle Gold Partner*
>>
>> *425-891-7934 (cell)*
>>
>> *D&B *047931344
>>
>> *CAGE *7J5S7
>>
>> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>>
>> *View Matthew Parker's profile on LinkedIn*
>> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>>
>> www.dimensionaldba.com
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Chris Taylor
>> *Sent:* Tuesday, October 30, 2018 10:30 AM
>> *To:* cichomitiko_at_gmail.com
>> *Cc:* ORACLE-L <oracle-l_at_freelists.org>
>> *Subject:* Re: Storage choice for Oracle database on VMware
>>
>>
>>
>> After dealing with multiple filesystems of very busy databases for the
>> last year (one of which is 70+TB), I would say ASM ALL THE WAY. Never go
>> back to filesystems after using ASM.
>>
>>
>>
>> Adding space, managing space is so much better on ASM.
>>
>>
>>
>> Just my $0.02.
>>
>>
>>
>> Chris
>>
>>
>>
>> On Tue, Oct 30, 2018 at 12:15 PM Radoulov, Dimitre <cichomitiko_at_gmail.com>
>> wrote:
>>
>> Hi all,
>>
>>
>>
>> considering the technology today: XFS as default FS on Linux 7, the
>> modern HW and the latest VMware versions, what storage type would you use
>> for a single database instance on VMware?
>>
>> Oracle versions are from 11.2 to 12.2, database size varies from 300G to
>> 3T+.
>>
>>
>>
>> Would you use XFS with non-default values for filesystemio_options or
>> ASM?
>>
>>
>>
>> Regards
>>
>> Dimitre
>>
>>
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 30 2018 - 19:12:05 CET

Original text of this message