Hi all,

I am doing some research about "the best way" to give a partition to Oracle.

I found this surprising and you may too, it is quite amusing:

http://jrs-s.net/2013/05/17/kvm-io-benchmarking/

But here’s the big surprise – if we set up a ZVOL, then format it with
ext4 and put a .qcow2 on top of that… it performs as well, and in some
cases better than, the raw zvol itself did!  As odd as it sounds, this
leaves qcow2-on-ext4-on-zvol as one of our best performing overall storage
methods, with the most convenient options for management.  It sounds like
it’d be a horrible Rube Goldberg, but it performs like best-in-breed.
Who’d’a thunk it?

According to the benchmark you have this layering:
- qcow2 (virtual disk) as a file on an
- ext4 filesystem formatted on a
- zvol created on a
- raw partition

performing better than a raw partition!

But

- zvol created on a
- raw partition

is "not worth the hassle".

Any thoughts and experiences?

I want to give a disk via iSCSI to Oracle (Avi knows more;-) and look for
the best setup. The iSCSI target is FreeBSD which can export files as
block devices or zvols or raw disks or mirrored disks or other exotic GEOM
devices on top of raw disks.

According to the benchmark above, a file exported as a blockdevice on top
of a zvol could be better than an exported disk..

Could this be true?

Regards
Peter


_______________________________________________
luv-main mailing list
[email protected]
http://lists.luv.asn.au/listinfo/luv-main

Reply via email to