Re: Storage choice for Oracle database on VMware
Date: Tue, 30 Oct 2018 18:06:19 +0000
Message-ID: <CABe10sbjbSbHiczh2KKGwHSZs3sB4zLEWEN6veGN4gx9+NZP+g_at_mail.gmail.com>
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-lReceived on Tue Oct 30 2018 - 19:06:19 CET