Re: NAS vs SAN for data directory
Avoid NAS... that's like dealing with mysql via NFS ... Internal raid depending on controller type and disk configuration could be faster than an external SAN... But chances are external SAN has alot more scalability as far as adding more controller, cabinets and disks... If it was my choice and you've had great success with SAN's before as mentioned .. stay the route... On Tue, 8 Jul 2003, SAQIB wrote: > Hello All, > > I am trying to decide which storage I should use for the "Data Directory". > My application has lots of 'SELECT's (80%) and fewer > UPDATEs/INSERTs(20 %). > > I have the following choices of Data storage > > 1) Xiotech SAN (66 Mhz FCAL) > 2) NAS > 3) Internal SCSI 3 RAID 5 > > Will I achieve any better performance using one storage vs the other > storage? > > In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and > the performance has been quite exceptional. And I have encountered no > problems. > > Any suggestions? > Thanks > > Saqib Ali > http://www.xml-dev.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: NAS vs SAN for data directory
Well, I would avoid NAS as it introduces unwanted overhead when accessing the data. As for SAN versus the internal RAID5, I am not sure, I would say benchmark the two and see which comes out better, or wait to see if there is anyone out there that has dealt with both. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: SAQIB [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 08, 2003 8:45 AM > To: [EMAIL PROTECTED] > Subject: NAS vs SAN for data directory > > > Hello All, > > I am trying to decide which storage I should use for the > "Data Directory". > My application has lots of 'SELECT's (80%) and fewer > UPDATEs/INSERTs(20 %). > > I have the following choices of Data storage > > 1) Xiotech SAN (66 Mhz FCAL) > 2) NAS > 3) Internal SCSI 3 RAID 5 > > Will I achieve any better performance using one storage vs the other > storage? > > In the past (for about 2 years), I have I used SAN with 33Mhz > FCAL, and > the performance has been quite exceptional. And I have encountered no > problems. > > Any suggestions? > Thanks > > Saqib Ali > http://www.xml-dev.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NAS vs SAN for data directory
Hello All, I am trying to decide which storage I should use for the "Data Directory". My application has lots of 'SELECT's (80%) and fewer UPDATEs/INSERTs(20 %). I have the following choices of Data storage 1) Xiotech SAN (66 Mhz FCAL) 2) NAS 3) Internal SCSI 3 RAID 5 Will I achieve any better performance using one storage vs the other storage? In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and the performance has been quite exceptional. And I have encountered no problems. Any suggestions? Thanks Saqib Ali http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]