innodb - datafiles on an ipstore disk appliance

2004-09-22 Thread Debbie L
We are looking at a disk subsystem for a high transactional application. And management wishes to use disk appliance (IPStore or NetAPP). Does anyone know if placing the mysql MYISAM and INNODB datafiles on IPStore or NetApp disk applliances are supported? (We use almost all INNODB tables) If

Re: innodb - datafiles on an ipstore disk appliance

2004-09-22 Thread Jeremy Zawodny
On Wed, Sep 22, 2004 at 01:52:36PM -0400, Debbie L wrote: We are looking at a disk subsystem for a high transactional application. And management wishes to use disk appliance (IPStore or NetAPP). Does anyone know if placing the mysql MYISAM and INNODB datafiles on IPStore or NetApp disk

Re: innodb - datafiles on an ipstore disk appliance

2004-09-22 Thread Debbie L
Your right, I shouldn't say supported... Is it a wise to put datafiles on a disk appliance? Coming from other database background, it is not wise to do such a thing and will cause problems when the disk appliance has problems. As for the transaction logs, I haven't reallly thought of it, but to

Re: innodb - datafiles on an ipstore disk appliance

2004-09-22 Thread Jeremy Zawodny
On Wed, Sep 22, 2004 at 02:22:59PM -0400, Debbie L wrote: Your right, I shouldn't say supported... Is it a wise to put datafiles on a disk appliance? Coming from other database background, it is not wise to do such a thing and will cause problems when the disk appliance has problems. Well,

Re: innodb - datafiles on an ipstore disk appliance

2004-09-22 Thread Mir Islam
We have been using innodb tables on our systems and we use netapp to store all the tables. It will be however wise to put transaction logs into a different netapp or somewhere else so that even if the netapp goes kaput (highly unlikely) totally you do not lose any data. -- MySQL General Mailing