Re: To LVM or not to LVM?

Hello Rich,
the first question would be - are you using VMFS or RDM for your "virtual disks"?

However go for LVM - especially if you have some I/O intensive databases because of you can easily spread out the I/O load over several VSCSI/LUNs/Virtual Disks with LVM (even use of disk queues).

Recommendation based on experience and a lot of SLOB benchmarks in client environments (also with All-Flash SAN): LVM + XFS.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Rich J <rjoralist3_at_society.servebeer.com> hat am 7. Mai 2019 um 22:28 geschrieben:
>
> Hey all,
>
> Migrating from AIX to OL7 (x86-64) under VMware with an all-flash SAN, and I'm planning out the logical volumes for database filesystems (non-ASM).  I'm now questioning whether or not to use LVM, even for filesystems.  If I need to add datafiles without LVM, the Storage Manager adds a new virtual disk to the server, and I create a new mountpoint and set security on it.  Easy.
>
> In AIX with XIV storage, there was a minimum ~17GB allocation per LUN, so there was space savings in using LVM to group together small control files, redo logs, etc.  Not being a vSphere person, I don't know if this is the case there as well.
>
> Any opponents/proponents for/against LVM for Oracle database virtual servers?
>
> Thanks,
> Rich
>
> p.s.  This will be for Oracle EE 12.2 and (hopefully someday) higher databases.

--
http://www.freelists.org/webpage/oracle-l