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: @OracleSK
Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx> 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.