Hi Avi, On 5/11/2012 8:04 AM, Avi Miller wrote:
On 04/11/2012, at 2:33 PM, Andrew McGlashan <andrew.mcglashan@affinityvision.com.au> wrote:
Insofar as Oracle is concerned with their own version of RHEL.... BTRFS is production ready, but they haven't certified their other main products to use it!
This is half-true: Oracle supports btrfs if used in production, but the Linux team is not responsible for product certification. So, you can happily store Oracle binaries on btrfs (and I know a few customers that are now exploring this), but you can't use btrfs to store Oracle Database data. And why would you anyway, given so many better options, not least of which is Oracle ASM?
I wish it was 0% true... ;)
And, Oracle Database is one of the few Oracle products that actually certifies filesystems for data storage. Where a product has no filesystem certifications at all, e.g. the middleware stack, you can also use btrfs.
I much prefer using standard files on a file system without autoextend enabled or any kind of automatic space management; it is much less prone to space issues when managed properly and it is much easier for me to clone databases for development and test requirements from a simple production backup. Cheers -- Kind Regards AndrewM