Hi All, Can someone please give some advise on the following? We are installing a 7320 with 2 18 GB Write Accelerators, 20 x 1 TB disks and 96 GB of ram. Postgres will be running on a Oracle x6270 device with 96GB of ram installed and two quad core cpus, with a local WALL on 4 hard drives, and 7320 LUN via 8GB FC. I am going configure the 7320 as Mirrored with the following options available to me (read and write cache enabled): Double parity RAID Mirrored Single partiy RAID, narrow stripes Striped Triple mirrored Was does the above mean in real terms officially, and what is optimum for a (Postgresql 9, or any performance tips for Postgres on a 7320) database high writes, and are there any comments that can help us improve performance? Thanks, all feedback will be appreciated! -- This message posted from opensolaris.org -------------- next part -------------- A non-text attachment was scrubbed... Name: configure-7320.png Type: application/octet-stream Size: 88851 bytes Desc: not available URL: <http://mail.opensolaris.org/pipermail/zfs-discuss/attachments/20110526/4eadca08/attachment-0001.obj>
On Thu, May 26, 2011 at 8:13 AM, Gustav <gus at phunk.co.za> wrote:> Hi All, > > Can someone please give some advise on the following? > > We are installing a 7320 with 2 18 GB Write Accelerators, 20 x 1 TB disks > and 96 GB of ram. > > Postgres will be running on a Oracle x6270 device with 96GB of ram > installed and two quad core cpus, with a local WALL on 4 hard drives, and > 7320 LUN via 8GB FC. > > I am going configure the 7320 as Mirrored with the following options > available to me (read and write cache enabled): > Double parity RAID > Mirrored > Single partiy RAID, narrow stripes > Striped > Triple mirrored > > Was does the above mean in real terms officially, > and what is optimum for a (Postgresql 9, or any performance tips for > Postgres on a 7320) database high writes, > and are there any comments that can help us improve performance? >Hello, I would advise against creating many small pools of disks unless you''ve very different capacity/performance/reliability requeriments. Even then, try to limit the number of pools as much as you can. I know newer firmwares allowed you to create 2 pools but I guess they removed that limitation (but still advise against it). Check the documentation in the "Help" link within the appliance, it''s usually very detailed. Alghouth the 7320 is an appliance and comes with its own documentation, I think you''d benefit from reading the ZFS Best Practices Guide ( http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide). You''re probably looking for maximum performance with availability so that narrows it down to a mirrored pool, unless your Postgresql workload is very specific that raidz would fit, but beware of the performance hit. Regards, -- Giovanni Tirloni -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/zfs-discuss/attachments/20110526/858cd7b4/attachment.html>
Thank you, I will be creating one big pool on the 7320, and with hardware raid four hard drives for the WALL locally. I have read the documentation, and have used the principles from there, but it is not all applicable to my needs, I will look at the help in the application Simulator as well, as my 7110''s FE crashed, and the services went into maintenance, and I am awaiting delivery for my 7320. A very good article that was advised by Hung-Sheng, white paper on the Oracle database for ZFS was a great help so far as well. Thank you for the reply. Gustav On 26 May 2011, at 5:00 PM, Giovanni Tirloni wrote:> On Thu, May 26, 2011 at 8:13 AM, Gustav <gus at phunk.co.za> wrote: > Hi All, > > Can someone please give some advise on the following? > > We are installing a 7320 with 2 18 GB Write Accelerators, 20 x 1 TB disks and 96 GB of ram. > > Postgres will be running on a Oracle x6270 device with 96GB of ram installed and two quad core cpus, with a local WALL on 4 hard drives, and 7320 LUN via 8GB FC. > > I am going configure the 7320 as Mirrored with the following options available to me (read and write cache enabled): > Double parity RAID > Mirrored > Single partiy RAID, narrow stripes > Striped > Triple mirrored > > Was does the above mean in real terms officially, > and what is optimum for a (Postgresql 9, or any performance tips for Postgres on a 7320) database high writes, > and are there any comments that can help us improve performance? > > > Hello, > > I would advise against creating many small pools of disks unless you''ve very different capacity/performance/reliability requeriments. Even then, try to limit the number of pools as much as you can. I know newer firmwares allowed you to create 2 pools but I guess they removed that limitation (but still advise against it). Check the documentation in the "Help" link within the appliance, it''s usually very detailed. > > Alghouth the 7320 is an appliance and comes with its own documentation, I think you''d benefit from reading the ZFS Best Practices Guide (http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide). > > You''re probably looking for maximum performance with availability so that narrows it down to a mirrored pool, unless your Postgresql workload is very specific that raidz would fit, but beware of the performance hit. > > Regards, > > -- > Giovanni Tirloni-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/zfs-discuss/attachments/20110526/1d5bcb8d/attachment-0001.html>