RAID

I can't believe I don't have the previous responses saved somewhere; however, I don't. I am running Solaris 10 and Informix 11.70. I am getting new hardware and have the option of having it set up as I dictate. I thought I remembered that it is best to have two internal disks in RAID 1 that will hold the root partition, and then having the data in a disk array set up as RAID 10. Is this still the case, or is there a better recommended configuration? The database is a combination of OLTP and OLAP. Larry

For a very simple configuration, yes, that would align with best practice. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 1, 2016 at 2:30 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > I can't believe I don't have the previous responses saved somewhere; > however, > I don't. > I am running Solaris 10 and Informix 11.70. > > I am getting new hardware and have the option of having it set up as I > dictate. I thought I remembered that it is best to have two internal disks > in > RAID 1 that will hold the root partition, and then having the data in a > disk > array set up as RAID 10. Is this still the case, or is there a better > recommended configuration? > > The database is a combination of OLTP and OLAP. > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0103de4e6dbaaa052abac296

Also, what are the recommendattions on HBAs? > To: ids@iiug.org > From: lsorensen25@msn.com > Subject: RAID [36467] > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > I can't believe I don't have the previous responses saved somewhere; however, > I don't. > I am running Solaris 10 and Informix 11.70. > > I am getting new hardware and have the option of having it set up as I > dictate. I thought I remembered that it is best to have two internal disks in > RAID 1 that will hold the root partition, and then having the data in a disk > array set up as RAID 10. Is this still the case, or is there a better > recommended configuration? > > The database is a combination of OLTP and OLAP. > > Larry > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

HBAs? Host adapters? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Also, what are the recommendattions on HBAs? > > > To: ids@iiug.org > > From: lsorensen25@msn.com > > Subject: RAID [36467] > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > I can't believe I don't have the previous responses saved somewhere; > however, > > I don't. > > I am running Solaris 10 and Informix 11.70. > > > > I am getting new hardware and have the option of having it set up as I > > dictate. I thought I remembered that it is best to have two internal > disks > in > > RAID 1 that will hold the root partition, and then having the data in a > disk > > array set up as RAID 10. Is this still the case, or is there a better > > recommended configuration? > > > > The database is a combination of OLTP and OLAP. > > > > Larry > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113eb324fd6cfb052abafb6d

Yes. Other than having redundant adapters, I am not really sure what you can do, or even if there is anything else to do. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: RAID [36471] > Date: Mon, 1 Feb 2016 15:11:15 -0500 > > HBAs? Host adapters? > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > Also, what are the recommendattions on HBAs? > > > > > To: ids@iiug.org > > > From: lsorensen25@msn.com > > > Subject: RAID [36467] > > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > > > I can't believe I don't have the previous responses saved somewhere; > > however, > > > I don't. > > > I am running Solaris 10 and Informix 11.70. > > > > > > I am getting new hardware and have the option of having it set up as I > > > dictate. I thought I remembered that it is best to have two internal > > disks > > in > > > RAID 1 that will hold the root partition, and then having the data in a > > disk > > > array set up as RAID 10. Is this still the case, or is there a better > > > recommended configuration? > > > > > > The database is a combination of OLTP and OLAP. > > > > > > Larry > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113eb324fd6cfb052abafb6d > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Yup. Eliminate single points of failure. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 1, 2016 at 3:39 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Yes. Other than having redundant adapters, I am not really sure what you > can > do, or even if there is anything else to do. > > Larry > > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: RAID [36471] > > Date: Mon, 1 Feb 2016 15:11:15 -0500 > > > > HBAs? Host adapters? > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity with which I am affiliated nor those of the entities themselves. > > > > On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> > wrote: > > > > > Also, what are the recommendattions on HBAs? > > > > > > > To: ids@iiug.org > > > > From: lsorensen25@msn.com > > > > Subject: RAID [36467] > > > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > > > > > I can't believe I don't have the previous responses saved somewhere; > > > however, > > > > I don't. > > > > I am running Solaris 10 and Informix 11.70. > > > > > > > > I am getting new hardware and have the option of having it set up as > I > > > > dictate. I thought I remembered that it is best to have two internal > > > disks > > > in > > > > RAID 1 that will hold the root partition, and then having the data > in a > > > disk > > > > array set up as RAID 10. Is this still the case, or is there a better > > > > recommended configuration? > > > > > > > > The database is a combination of OLTP and OLAP. > > > > > > > > Larry > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a113eb324fd6cfb052abafb6d > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e011602a86bd99b052abb799e

Where can I find a list of all the major reasons that we should not use RAID 5 for database storage? Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: RAID [36471] > Date: Mon, 1 Feb 2016 15:11:15 -0500 > > HBAs? Host adapters? > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > Also, what are the recommendattions on HBAs? > > > > > To: ids@iiug.org > > > From: lsorensen25@msn.com > > > Subject: RAID [36467] > > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > > > I can't believe I don't have the previous responses saved somewhere; > > however, > > > I don't. > > > I am running Solaris 10 and Informix 11.70. > > > > > > I am getting new hardware and have the option of having it set up as I > > > dictate. I thought I remembered that it is best to have two internal > > disks > > in > > > RAID 1 that will hold the root partition, and then having the data in a > > disk > > > array set up as RAID 10. Is this still the case, or is there a better > > > recommended configuration? > > > > > > The database is a combination of OLTP and OLAP. > > > > > > Larry > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113eb324fd6cfb052abafb6d > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Go to www.baarf.com. There you'll find links to papers from me, Cary Millsap (Hotsos), Juan Loaiza (Oracle - originator of the SAME concept: Stripe and Mirror Everything), and James Morle (Oracle). James's papers may take some searching because Oracle keeps taking them down and he keeps finding new places to post it. In addition, under the <members> link you'll find that many members' entry blurbs include a short horror tale. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Feb 16, 2016 at 10:22 AM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Where can I find a list of all the major reasons that we should not use > RAID 5 > for database storage? > > Larry > > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: RAID [36471] > > Date: Mon, 1 Feb 2016 15:11:15 -0500 > > > > HBAs? Host adapters? > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity with which I am affiliated nor those of the entities themselves. > > > > On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> > wrote: > > > > > Also, what are the recommendattions on HBAs? > > > > > > > To: ids@iiug.org > > > > From: lsorensen25@msn.com > > > > Subject: RAID [36467] > > > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > > > > > I can't believe I don't have the previous responses saved somewhere; > > > however, > > > > I don't. > > > > I am running Solaris 10 and Informix 11.70. > > > > > > > > I am getting new hardware and have the option of having it set up as > I > > > > dictate. I thought I remembered that it is best to have two internal > > > disks > > > in > > > > RAID 1 that will hold the root partition, and then having the data > in a > > > disk > > > > array set up as RAID 10. Is this still the case, or is there a better > > > > recommended configuration? > > > > > > > > The database is a combination of OLTP and OLAP. > > > > > > > > Larry > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a113eb324fd6cfb052abafb6d > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f8f8e949029052be4e32c

Try Battle Against Any Raid for a database independent perspective - http://www.baarf.com On 2/16/16 10:22 AM, LARRY SORENSEN wrote: > Where can I find a list of all the major reasons that we should not use RAID 5 > for database storage? > > Larry > >> To: ids@iiug.org >> From: art.kagel@gmail.com >> Subject: Re: RAID [36471] >> Date: Mon, 1 Feb 2016 15:11:15 -0500 >> >> HBAs? Host adapters? >> >> Art >> >> Art S. Kagel, President and Principal Consultant >> ASK Database Management >> www.askdbmgt.com >> >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinions >> and do not reflect on the IIUG, nor any other organization with which I am >> associated either explicitly, implicitly, or by inference. Neither do >> those opinions reflect those of other individuals affiliated with any >> entity with which I am affiliated nor those of the entities themselves. >> >> On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: >> >>> Also, what are the recommendattions on HBAs? >>> >>>> To: ids@iiug.org >>>> From: lsorensen25@msn.com >>>> Subject: RAID [36467] >>>> Date: Mon, 1 Feb 2016 14:30:36 -0500 >>>> >>>> I can't believe I don't have the previous responses saved somewhere; >>> however, >>>> I don't. >>>> I am running Solaris 10 and Informix 11.70. >>>> >>>> I am getting new hardware and have the option of having it set up as I >>>> dictate. I thought I remembered that it is best to have two internal >>> disks >>> in >>>> RAID 1 that will hold the root partition, and then having the data in a >>> disk >>>> array set up as RAID 10. Is this still the case, or is there a better >>>> recommended configuration? >>>> >>>> The database is a combination of OLTP and OLAP. >>>> >>>> Larry >>>> >>>> >>>> >>> > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>>> >>> >>> >>> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> --001a113eb324fd6cfb052abafb6d >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________

Thank you. I should have kept the references the last 100 times that this was discussed on the chain. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: RAID [36567] > Date: Tue, 16 Feb 2016 10:36:18 -0500 > > Go to www.baarf.com. > > There you'll find links to papers from me, Cary Millsap (Hotsos), Juan > Loaiza (Oracle - originator of the SAME concept: Stripe and Mirror > Everything), and James Morle (Oracle). James's papers may take some > searching because Oracle keeps taking them down and he keeps finding new > places to post it. In addition, under the <members> link you'll find that > many members' entry blurbs include a short horror tale. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Tue, Feb 16, 2016 at 10:22 AM, LARRY SORENSEN <lsorensen25@msn.com> > wrote: > > > Where can I find a list of all the major reasons that we should not use > > RAID 5 > > for database storage? > > > > Larry > > > > > To: ids@iiug.org > > > From: art.kagel@gmail.com > > > Subject: Re: RAID [36471] > > > Date: Mon, 1 Feb 2016 15:11:15 -0500 > > > > > > HBAs? Host adapters? > > > > > > Art > > > > > > Art S. Kagel, President and Principal Consultant > > > ASK Database Management > > > www.askdbmgt.com > > > > > > Blog: http://informix-myview.blogspot.com/ > > > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > > and do not reflect on the IIUG, nor any other organization with which I > > am > > > associated either explicitly, implicitly, or by inference. Neither do > > > those opinions reflect those of other individuals affiliated with any > > > entity with which I am affiliated nor those of the entities themselves. > > > > > > On Mon, Feb 1, 2016 at 3:01 PM, LARRY SORENSEN <lsorensen25@msn.com> > > wrote: > > > > > > > Also, what are the recommendattions on HBAs? > > > > > > > > > To: ids@iiug.org > > > > > From: lsorensen25@msn.com > > > > > Subject: RAID [36467] > > > > > Date: Mon, 1 Feb 2016 14:30:36 -0500 > > > > > > > > > > I can't believe I don't have the previous responses saved somewhere; > > > > however, > > > > > I don't. > > > > > I am running Solaris 10 and Informix 11.70. > > > > > > > > > > I am getting new hardware and have the option of having it set up as > > I > > > > > dictate. I thought I remembered that it is best to have two internal > > > > disks > > > > in > > > > > RAID 1 that will hold the root partition, and then having the data > > in a > > > > disk > > > > > array set up as RAID 10. Is this still the case, or is there a better > > > > > recommended configuration? > > > > > > > > > > The database is a combination of OLTP and OLAP. > > > > > > > > > > Larry > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --001a113eb324fd6cfb052abafb6d > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113f8f8e949029052be4e32c > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >