Hello Mario,
Wednesday, November 5, 2008, 7:25:06 PM, you wrote:
|
> |
My co-workers and I are trying to find out if anyone out there is running production Oracle on. We currently have a project in which we have a SAN divided into 51 86.9GB luns (performance). Oracle has been setup on 18 or so partitions and using SVM would be a logistical nightmare as far as management goes.
Has anyone had any good dealings with Oracle on ZFS and, if so, what issues did you run into.
|
I have deployed several Oracle databases on ZFS.
You need to do basic tuning, like matching ZFS's recordsize to db_block size in Oracle, disable cache flushes on zfs or configure a disk array to ignore them,
disable atime updates, limit ARC size, disable vdev prefetch, etc. Basically I tend to use standard set of tunables for Oracle on ZFS. You can find most of it in ZFS Evil Tuning Guide.
It is useful to create a pool with several datasets for: archivelogs, redologs, indexes, tablespaces, binaries.
The benefit is that you can set-up different recordsize for datasets containing tablespaces and indexes.
The other useful thing is to regularly do hotbackups by utilizing zfs snapshots and keep last one or last couple of them. Usually it's very quick to create a hotbackup that way (2-10s) and depending on the environment you could do them on hourly basis for example. This is of course additional to any other backup method like rman.
When I consolidate several Oracle databases on one box or a cluster I tend to dedicate a separate pool to each Oracle instance - that way not only you keep them more separated so they have less means to impact each other, it's easier to diagnose any problems but also you have an option to independently fail over each instance in a cluster environment.
Disk/storage management with zfs is a pure joy :)
I haven't deployed a production Oracle utilizing ZFS built-in compression (yet) but I did it on test/dev platforms. Depending on your environment it could ba beneficial to do so. I deployed other products like LDAP, MySQL, etc. on ZFS using built-in compression to actually get better performance.
ZFS is also very helpful for dev environments when you have several Oracle (and other applications) each in its own Solaris zone, where each zone is on a separate zfs dataset (with some sub-datasets). You can put all of them on one zfs pool and then use quota, reservation to manage storage allocation - really helpful.
--
Best regards,
Robert Milkowski mailto:[EMAIL PROTECTED]
_______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
